We changed our domain and now i have some troubles to log in to the nav2009 databases. We are using windows authentication.
The problem is that all users in NAV are registered as domain users what means that they are registered as folows:
Now that domainname has changed. In SQL server management all users are correctly changed but when I log in to NAV classic client I have no user registered in the correct domain (even not the administrator!).
When logging in with administrator, i can connect to the server and see all databases available (so this means connection to SQL is granted) but when selecting a database, i get the folowing error:
“The user ID and password are invalid. Try again.”
Is there a possibility to modify a user directly into the sql database without a connecting to NAV first?
thanks for any suggestions because this is a very annoying issue, as you can probably imagine…