navision sql proc xp_ndo.dll

mpudja

Hi,

When I trying to connect with windows authentication I get error for xp_ndo.dll .

I have executed this code for enumusergroups and enumusersids

USE master
GO

EXEC dbo.sp_addextendedproc N'xp_ndo_enumusergroups',
'C:\Program Files (x86)\CSIDE Client\xp_ndo.dll'
GO

GRANT EXECUTE ON "xp_ndo_enumusergroups" TO PUBLIC
GO

EXEC dbo.sp_addextendedproc N'xp_ndo_enumusersids',
'C:\Program Files (x86)\CSIDE Client\xp_ndo.dll'
GO

GRANT EXECUTE ON "xp_ndo_enumusersids" TO PUBLIC
GO

This folder C:\Program Files (x86)\CSIDE Client\xp_ndo.dll, here is CSIDE Client and as I see the Client isn't installed properly, someone just copied client folder on server

Also I saw that we have 64-bit operating system and we using NAV 5.0 SP1.

mohana_cse06

make sure that you have xp_ndo.dll file under
C:\Program Files (x86)\CSIDE Client

mpudja

Yes, I already check and dll is in folder.
Also, I check xp_ndo_enumusergroups, xp_ndo_enumusersids extendnd proc and all seems fine.

mohana_cse06

Check this
http://blog.wibeck.org/2009/09/changing-stored-procedure-to-64-bit-in-nav-2009/

DenSter

The dll should go into the Binn folder of your SQL Server installation. Also, if you are running 64bit SQL Server, you need the 64bit version of the dll.

mpudja

Ok, thanks, but does it mean that I must choose BIN folder for DLL in Extended Proc ?

I have add dll in folder but the problem is still there.

I remeber that I have the same situation one year ago and I didn't have a problem with this. I just choose root from CSIDE Client root directory, select dll and the end give permission to PUBLIC.

mpudja

Ok, I solve the problem.

I just replace old dll with new one from instalation folder....