Windows Authentication Problems

paullynchpaullynch Member Posts: 27
edited 2009-06-01 in SQL General
Having problems trying to implement windows authentication.

Setup is NAV 5.0 SP1, Windows 2003 64bit, SQL2005, Security model standard.

Added myself as a windows logon in NAV with appropriate permissions.
Initially was getting "invalid username and password". Subsequently have added the extended stored procedures (xp_ndo_enumusersids and xp_ndo_enumusergroups) as per the installation and system management doc. and now get the following error
17750,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Could not load the DLL c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xp_ndo.dll, or one of the DLLs it references. Reason: 193(%1 is not a valid Win32 application.).

INSERT INTO [#$ndo$groups]EXEC [master]..[xp_ndo_enumusersids]

Does anyone have any suggestions?

Many thanks



Sign In or Register to comment.