Synchronize Logins Delete's Users from Database

ronpatrick

Dynamics NAV 2009

I have created a new database on a new server.
I restored a ful FBK from the original server.
I deleted all the users from the database.
I re-configure users logins to the new database.
I can only login as sa and when I synchronize all logins my users are dropped from the database.

Any ideas.

kriki

I suppose you are working on SQL.
In that case, it is better to change the security model to Standard and not Enhanced. With Standard you don't need to synchronize.

kine

You need to have the users defined in NAV else all permissions granted only through SQL to some account which is not defined in NAV will be lost when sync in NAV is triggered.

stryk

With "Standard" Security Model the "Synchronization" process in NAV will drop all SQL Databases Users which are not defined within NAV as "Database Login" or "Windows Login".
In this case you just have to define the NAV site logins (you don't even have to assign NAV roles).