Loging into SQL with Navision 4. SP1

ara3n

Here is the scenerio I have problem with

I have to sql databases on the server.
I have a db login that has a dbowner role in 1st database and a regular user role on second.
the login as super role in both databases in Navision and Security is synchronized.

I can login into the 1st db where I have db owner role. For the 2nd database I get an error. The password and login does not match. Any ideas?

ara3n

This also happens in Navision 4.0 as well.

kine

Please, run Synchronize on the second DB...

ara3n

in both databases in Navision the Security is synchronized.

DenSter

Try resetting the password in SQL Server Enterprise manager, then log in with another user ID and synchronize. I don't know if it is related, but maybe it is because the user's password was changed in db1 and not synched in db2.