Windows login fails after upgrade to SQL 2005 SP4.

We are running NAV 4.01 on SQL server 2005 and have had no problems when my users logged in using windows login. But after I updated my SQL server with SP4, they no longer can login using windows login. They have no problems logging in via database login but I would prefer they used windows login. Does anyone know a solution or have heard abaout this problem?

Hi!

Welcome to the Dynamics User Group [<:o)]

Regarding your question:
What error is raised when try Windows Login? Is the Traceflag 4616 still enabled (sometimes it get’s lost during an upgrade)?

Regards,
Jörg

Also check if xp_ndo stored procedures are not deleted.

Hi Jörg.

Thank you. The error Navision says is Username or Password is incorrect try again. When I look at the event viewer at the server it sayes the same with event id: 18456.

But what puzzels me more is, that when I tryed the windows logon this morning it work for one user that didn’t work on saturday. The rest of the users still get the same fault.

Regards,
Peter

Hi Kirill.

The xp-ndo is in place with the right permissions.

Did you try by synchronizing the users?

Yes, all users have been synchronized.