NAV Issue - SQL Server - xp_ndo.dll // Enumusersids // Enumusergroups
1. Open SQL Server Management Studio >> Databases >> System Databases >> Master2. Programmability >> Extended Stored Procedures
3. Right Click >> 'New Extended Stored Procedure'
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZ3XogxkCQCc77hPCyqeTqif_Q8SJ95BmFhMf5Q6HoRl-NmQIuM0h7qUYEPGRtTlL7OPuS2DhOH59CJDrf2r9-GS8r_V79X4Qa91fEO47Pnh72l5GQCTJOeoItjKip31t7yKEIQEvh0Sw/s1600/XP_ndo+BEFORE.png)
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 File\NAV 2009 R2\SQLDatabase\PFiles\Microsoft Dynamics NAV\60\Database\xp_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.
No comments:
Post a Comment