I have a client working on NAV 4.02 . They are working with SQL 2005 and are using SQL Server authentication.
This is the problem: when they try to add a new user in NAV (through Tools==>Security==Database logins), they get the followinging error message:
"The MBS- NAV Server and SQL Server security systems have not been synchronized succesfully. The SQL Server login "ARNOLD" does not exist on the SERVERNAME server"
The funny thing is: the user "arnold" does exist in SQL. Arnold can log in to NAV and have a party

, without any problems. If you delete Arnold from the listy of database logins in NAV, the next user (in alphabettical order) e.g. "Betty" will raise the same error. As said before, all user can log in to NAV without any problems.
Because of this, it is not possible to add users at the moment, which is quite a problem as this company is a start up with new people...
Does anyone have an idea?
Comments
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
and if they already exist, u have to assign roles/persmission to them insiude SQL
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
This was on sql 2005. nav 4.0 sp3.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Yes, the db_owner is not enough to create new users and see all existing users in master DB...
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
Anyways the problem wasn't with the other users, it was with mine. I didn't have the SQL permission necessary to read the other logins. I gave myself sysadmin permission and then everything started working again.
RIS Plus, LLC