Error occured when Synchronize Windows User Auth.

rajpatelbca

hi Experts,

i am using NAV 5.0 and SQL Server 2005. i have created windows login and when i am trying to synchronized single login then it is showing me this error. in case of SQL login it is working fine.


The following SQL Server error(s) occurred:

17750,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Could not load the DLL C:\Program Files\Microsoft SQL Server\MSSQL\Binn\xp_ndo.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).

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


all ideas are welcome....
Thanks in advance.

Regards,

sendoh

look at the chapter 1 of application designer guide documentation.

rajpatelbca

sendoh thanks for your reply but i have read it.

any body else who can help me come out this problem. ](*,)

any idea about it ?

Thanks in advance...

Regards,

kine

If you have read it, you know that you need to have xp_ndo.dll copied into MS SQL BIN folder and you need to have registered two extended stored procedures with permissions to execute for public and guest. It seems that this is not correctly done on your system.

rajpatelbca

thanks all for giving me reply.
but was give incorrect path C:\Program Files\Microsoft SQL Server\MSSQL\Binn\xp_ndo.dll
instead of C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xp_ndo.dll
that's why problem was occurred. #-o #-o

when i synchronized that time it was looking for xp_ndo.dll on that path. so, i have drop those two procedures and created again with new path. now its done.

USE master
EXEC sp_addextendedproc xp_ndo_enumusersids, 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xp_ndo.dll'
GO

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

GRANT EXECUTE
ON [xp_ndo_enumusersids]
TO PUBLIC
GO

once again thank you all for your precious time =D> =D> =D>