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
Latest posts by Andy, Software Engineer (see all)
- Configuring the Web Client for tablets (NAV 2013+) - January 18, 2017
- NAV Know How: Creating a test system - May 4, 2016
- Web Client Install – Fatal Error During Installation 1603 - April 28, 2016