I hope anyone can give me some light to resolve the issue…
I have a NAV version 5 running on SQL Server 2005.
We are using Windows authentication to authenticate users to access Navision.
We have a random users (currently 2 users) that have “combination userid and password invalid” error message. In the past, when i sync the database, it fixed the problem but not now.
What did i try:
I log in as the trouble user to different computer, but still no good.
I reset his password in Active directory and log in to different computer or his PC, still no good.
I removed his detail from Navision, sync the database, readded , and resync teh database again and still no good.
Then that’s very strange. I would do exactly as you write you have done.
The only additional thing that I can think about is, that I 'would check that his user ID has actually been removed from the SQL Server (not only from the database). And that he actually has been inserted correctly after you re-insert him into NAV. Use SQL Server Enterprise Management Studio to check this directly.
You mean he was there after you deleted him from Navision? If yes, then delete him from Security → Logins. And then insert him into NAV again, and check that he has been re-created correctly in SQL again.
