Windows Authentication Error Message

dabel

I am receiving the following error message while trying to login with windows authentication (SP2). I have created the stored procedures and copied the xp_ndo.dll file into the proper location. Has anyone ever seen this before?

The following SQL Server error(s) occured:

17750,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Could not load the DLL xp.ndo.dll, or one of the DLL's it references. Reason:5(Access is denied.).

SQL:
INSERT INTO [#$ndo$groups] {CALL [master]..[xp_ndo_enumusergroups](?,?)}


Thanks

ara3n

rightclick on the xp.ndo.dll and goto properties. on security tab make sure everyone is added.

Also the dll is in the binn folder ?

kine

the name of the library is xp_ndo.dll not xp.ndo.dll may be this is the problem... ;-)

ara3n

didn't see it.

darshanm

This is a common problem.

Go to NAV product CD and open SQL_esp folder.
there you open readme.txt file. you will find the solution.

dabel

FYI...

The xp.ndo.dll was a typo on my part! :oops:

Thanks ara3n,

The security properties of the dll under the binn folder was the problem. For some reason, simply copying the xp_ndo.dll file and overwriting the existing one did not build the correct security properties. So I deleted the file and then ran the xp_ndo.exe and unzipped it to this folder and that did the trick.

Thanks everyone for your replies.

Happy New Year!

kriki

[Topic moved from Navision forum to SQL General forum]

ROK

I was getting this same error with reason 5: gave all the permissions to the related user invain until i placed the DLL in the bin folder of SQL.

Just wondering why this strictly worked in the bin folder.

Ronald.