Error while adding database logins in SQL Server option

Jyoti_Kapoor · 2005-07-21

I have just created a new database using Navision's SQL server option and restored a standard 370 backup into the same. While creating the one i used the standard SQL login 'sa' with blank password. It was restored successfully and now when i am trying to add some more logins to it, it is giving me the following error:

"The Microsoft Business Solutions-Navision and SQL Server security systems have not been synchronized successfully. The SQL Server login does not exist on the server."

Can somebody help me on this issue?

Thanks & Regards,
Jyoti Kapoor

DenSter · 2005-07-21

You need to create the login on SQL Server first, before you can add them to Navision.

kine · 2005-07-21

It is applicable to all Database Logins. Windows logins do not need this pre-creation on MS SQL...

Tomas · 2009-02-26

I have similar issue.

Database security model is standard (SQL2005, NAV5). I have created login in SQL. When I log into Navision, and try to add same username in Database Logins screen, I am getting error message:

The Microsoft Dynamics NAD and SQL Server security systems have not been synchronized successfully. The SQL Server login NEWLOGIN does not exist on the SQL2005 server.

Any ideas?

kine · 2009-02-26

You need to create the login on SQL first if you are using DB Users... (through SQL tools)

ta5 · 2009-02-26

If the error persist you need imho a higher sql server role, because a member of the public server role does not see the records in the login table of sql server. This is different from the behavior of sql server 2000.

Thomas

Error while adding database logins in SQL Server option

Comments

Categories