SQL NAV installation

Roelof

I recently installed SQL Server 2005. In order to be able to use Windows Authentification for the NAV SQL client, I need to install 2 extended stored procedures on the SQL Server: xp_ndo_enumusergroups and
xp_ndo_enumusersids. How do I do that?

Thanks.

Marije_Brummel

Please read the SQL intallation guide on the product CD.

Tomas

You must add two extended stored procedures, xp_ndo_enumusergroups and xp_ndo_enumusersids, to each instance of SQL Server that you want to access with Windows authentication. The installation program for Dynamics NAV installs the xp_ndo.dll for you.

The first time Dynamics NAV connects to the server, the program will add the extended stored procedures automatically. However, if you have previously connected to the server from Dynamics NAV, the extended stored procedures will not be added. In this case you must add the extended stored procedures manually.

To manually add the extended stored procedures:
1. From your server computer, access the Dynamics NAV Installation DVD.
2. In the folder $:\SQL_ESP, where $ is the DVD drive, click the file xp_ndo.exe.
3. When prompted, enter the path to the BINN subfolder of the SQL Server installation folder. The unzipped xp_ndo.dll file must be in this folder on SQL Server. On SQL 2000, the default path is:
C:\Program Files\Microsoft SQL Server\MSSQL\Binn
On SQL 2005, the default path is:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn
4. Use a tool such as Microsoft SQL Server Management Studio (SQL Server 2005) or Enterprise Manager (SQL Server 2000) to add the extended stored procedures to SQL Server. The names of the extended stored procedures must be xp_ndo_enumusergroups and xp_ndo_enumusersids. If you are going to connect to SQL Server with an older version of the Dynamics NAV client, the extended stored procedure xp_ndo_enumuersids must also be added to the server.
5. Grant the public SQL Server database role execute permission for both extended stored procedures.

w1w1isql.pdf

BBlue

After copying the appropriate xp_ndo.dll file from the installation CD (folder Sql_esp) in your SQL Binn directory, you can add the 2 extended stored procedures with a query like this:

USE master
EXEC sp_addextendedproc xp_ndo_enumusergroups, 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xp_ndo.dll'
GO
GRANT EXECUTE 
ON [xp_ndo_enumusergroups]
TO PUBLIC
GO

USE master
EXEC sp_addextendedproc xp_ndo_enumusersids, 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xp_ndo.dll'
GO
GRANT EXECUTE 
ON [xp_ndo_enumusersids]
TO PUBLIC
GO

where 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xp_ndo.dll' must be modified according to your sql installation directory

Roelof

Thanks guys. I'll check it out.

Savatage

Note: the SQL forum
http://www.mibuso.com/forum/viewforum.php?f=33

kriki

[Topic moved from Navision forum to SQL General forum]