Adding the xp_ stored procedures

In order to enable Single Sign-On (SSO) through Windows logins, you must install two extended stored procedures on the SQL Server. This recipe will show you how to do that.

How to do it...

1. Copy the file named xp_ndo_x64.dll from the SQL_esp\x64 folder on the product CD (if you are using a 64 bit server). The default location to move it to is C:\Program Files (x86)\Microsoft Dynamics NAV\60\Database on the SQL Server, but you can copy it to any location.

2. Open SQL Server Management Studio and connect to your server. In the Object Explorer pane on the left-hand side, expand the tree to Databases, System Databases, master, Programmability, Extended Stored Procedures.

   

3. Right-click the Extended Stored Procedures folder and select New Extended Stored Procedure.

4. Enter xp_ndo_enumusergroups for the name and point it to the xp_ndo_x64.dll file you copied to the server.

   

5. Go to the Permissions page from the left-hand pane.

6. Click the Add button.

7. Add the public account and grant...