Windows Authentication Problems

paullynch

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.).

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

Does anyone have any suggestions?

Many thanks

Paul

DenSter

Did you grant execute rights to public on the extended stored procedures?

fig

Have you followed these procedures http://msdn.microsoft.com/en-us/library/dd568724.aspx

paullynch

DenSter wrote:

Did you grant execute rights to public on the extended stored procedures?

yes - had granted the exucute permission to public

fig wrote:

Have you followed these procedures http://msdn.microsoft.com/en-us/library/dd568724.aspx

this was the trick. did not realise required a seperate DLL for x64.

works a treat now

thanks
Paul

DenSter

If I had read your post after my morning coffee instead of before, I would have caught that good to hear you found the solution and thanks for the feedback.