How to setup xp_ndo.dll

If you need to setup xp_ndo.dll on 32bit machines for Microsoft Dynamics Nav 5 - 6, follow the steps bellow:

1. Copy xp_ndo.dll to binn folder of sqlserver (ex. C:\Program Files\Microsoft SQL Server\MSSQL10.SQLSERVER2008\MSSQL\Binn)

2. Run the following commands in management studio:

USE master

EXEC sp_addextendedproc xp_ndo_enumusergroups, 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLSERVER2008\MSSQL\Binn\xp_ndo.dll'

GO

GRANT EXECUTE

ON [xp_ndo_enumusergroups]

TO PUBLIC

GO

EXEC sp_addextendedproc xp_ndo_enumusersids, 'C:\Archivos de programa (x86)\Microsoft SQL Server\MSSQL.4\MSSQL\Binn\xp_ndo.dll'

GO

GRANT EXECUTE

ON [xp_ndo_enumusersids]

TO PUBLIC

GO