I encountered an error while reconnecting to navision SQl client after reinstalling the database. It usually comes with this error The extended stored procedure xp_ndo_enumuserids in the library file xp_ndo.dll, is not available on the xxx server. This has to do with xp_ndo.dll Extended Stored Procedure missing in the SQL Database.

Copy xp_ndo.dll (for 32bit OS) or xp_ndo_x64.dll (for 64bit OS) from Navision installation CD D:\DVD_BUILD32012\SQLDatabase\PFiles\Microsoft Dynamics NAV\60\Database to SQL Binn folder C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn.

Install xp_ndo_enumusergroups and xp_ndo_enumuserids as NAV SQL extended stored procedures using SQL Management Studio Query Tab.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

USE master 
EXEC sp_addextendedproc xp_ndo_enumusergroups, 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\xp_ndo_x64.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\MSSQL11.MSSQLSERVER\MSSQL\Binn\xp_ndo_x64.dll' 
GO

GRANT EXECUTE 
ON [xp_ndo_enumusersids] 
TO PUBLIC 
GO