Synchronize Login Error

vinoth_nav

Hi,

When i try to Synchronize All Logins (SQL Logins with Navison Logins) in Navision i get the following error

The following SQL Server error or errors occurred:

2714,"42501", [Microsoft] [ODBC
SQL Server Driver] [SQL Server]There is already an object named
'$ndo$ar$336DD6064F4F3B5118CC6A827F102EDO' in the
database.
2759,"42000",[Microsoft]
[ODBC SQL Server Driver] [SQL
SERVER] CREATE SCHEMA failed due to Previous errors.
SQL:
{CALL [SP_addapprole] (?,?)}

I deleted all schemas and users expect one (which is working fine) and created a new user and schema in SQL
and created loging in Navision for that user and tried to Synchronize the login with SQL from Navision.
Still the error remains. ](*,) ](*,)

Need Help.

dmccrae

Use SQL Management Studio, open the database folder, then the Security folder, then Roles\Application Roles.

Try to delete the application role in there matching the name in the error message, then Synchronize again.

vinoth_nav

Dear Dean McCrae,

There is nothing uin the Application Roles. Please advice.

vinoth_nav

Dear Dean McCrae,

The problem has been solved by deleting all the schema which are related to the User and also removing the association of that User with that Schema.

Thanks!