Nav 4SP3 SQL Server 2005 Logins not working

Methos

Hi.

I have a Navision 4 SP3 database running on SQL server 2005.

I was able to get one user , me ,to log into the database.
Now none of the new users I create in SQL can open the navision database. I Added the users to the Navision Logins and Syncronizing but navision says the users does not exist SQL.

Anny help please?

DenSter

After adding the users you need to synchronize security

kine

1) Read the documentation
2) If you are using DB logins, you need to create the users on SQL first and add them PUBLIC rights to the DB. After that you can add them in NAV.
3) If you are using Windows auth. you do not have this problem, it means see point 2... :-)

Methos

Hi, Thanks I got it working.

Not sure if it was that i did not grant the public rights on the DB, pritty sure I did.
Started over, made logins on server, and seperately added users to the DB. added the users to NAV and it syncronized.

Could it maybe have been that I used the mapping from the server logins to add the database to a login?

Thanks for the help.