NAV issue – SQL Server – xp_ndo.dll // Enumusersids // Enumusergroups

,

NAV Issue – SQL Server – xp_ndo.dll // Enumusersids // Enumusergroups

1. Open SQL Server Management Studio >> Databases >> System Databases >> Master
2. Programmability >> Extended Stored Procedures
3. Right Click >> ‘New Extended Stored Procedure’

4. Locate the DLL and populate the Name field with the below: xp_ndo_enumusergroups


Note: DLL can be found in install media – “Install Media FileNAV 2009 R2SQLDatabasePFilesMicrosoft Dynamics NAV60Databasexp_ndo.dll”

5. Give the stored procedure ‘Public’ access with the Execute role.

6. Repeat point 4. with the relevant path & name: xp_ndo_enumuersids


Note: This is USERSids not USERids – this has caught me out a few times. 

7. Repeat point 5.

This is how it should look when you are finished:

The following two tabs change content below.

Andy, Software Engineer

Andy is Software Engineer at Metaphorix