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?