Navision Windows login not authenticating

dmlee

Hello all,

Last week couple of our Navision Windows Login users lost connection to Navision. They are getting the below error when they try to log in:
"15161, "42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot set application role '$ndo$ar$000...' because it does not exist or the password is incorrect

I've tried to resynch the Windows users in Navision but got the below SQL error during resynching:
"15151, "42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the user '$ndo$ar$000...' because it does not exist or you do not have permission.
SQL:
Grant select on "[database table name]" to'$ndo$ar$000...'

These users are Windows users and should be pulling credentials from Active Directory. I've created a new Navision Windows user and am getting the same above error during synching.

The problem only impacts the Navision Database, it does not impact other databases on the same server.

There have been no change to database or server. We are running Nav 5 database and Nav2009 client on SQL server 2005 and Windows Server 2003.

Any help would be greatly appreciated.

annivasu

Hi dmlee,

Try to set Default database on User login property in SQL Server and also give them Master DB permission as well.

Hope this will work.