Synchronize Login Error

vinoth_nav
vinoth_nav Member Posts: 31
edited 2010-09-09 in SQL General
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.
With warm regards,
Vinoth Kumar.J M.Sc(CT),MBSP,MCTS.
Techno-Functional Consultant
Mobile : +91-7418577075
E mail : vinoth_nav@yahoo.co.in

Answers

  • dmccrae
    dmccrae Member, Microsoft Employee Posts: 144
    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.
    Dean McCrae - Senior Software Developer, NAV Server & Tools

    This posting is provided "AS IS" with no warranties, and confers no rights.
  • vinoth_nav
    vinoth_nav Member Posts: 31
    Dear Dean McCrae,

    There is nothing uin the Application Roles. Please advice.
    With warm regards,
    Vinoth Kumar.J M.Sc(CT),MBSP,MCTS.
    Techno-Functional Consultant
    Mobile : +91-7418577075
    E mail : vinoth_nav@yahoo.co.in
  • vinoth_nav
    vinoth_nav Member Posts: 31
    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.

    :wink:Thanks!
    With warm regards,
    Vinoth Kumar.J M.Sc(CT),MBSP,MCTS.
    Techno-Functional Consultant
    Mobile : +91-7418577075
    E mail : vinoth_nav@yahoo.co.in

Categories