I’am working with the following technical environnment:
Dynamics NAV 5 DB
Windows Authentication enabled. Users that need to have access to Dynamics NAV belong to the same Active Directory group
The problem I’am facing is that some users, belonging to the correct Active Directory group granting access to Dynamics NAV, are not able to connect.
The error returned is: The following SQL server error(s) occurred:
15161, “42000”,[Microsoft][ODBC SQL Server Driver][SQL Server] Cannot set application role ‘$ndo$shadow’ because it does not exist or the password is incorrect
A user not able to connect from his machine is able to connect from another machine… It does not seem to be a permission issue on the server but really on the local machine.
Do you have some ideas on how to solve the problem? I have tried lot of differents things but nothing is working and I’am running out of ideas.
Many thanks in advance for your help.