User Synchronization Error

cincai
cincai Member Posts: 24
edited 2008-11-18 in SQL General
Hi all,

I have an issue when I try ti synchronize the user Windows Login. The message is 'The Microsoft Solution-Navision and SQL server security system have not been synchronized successfully.

'The database user MAFS does not exist in the NAV database.'

I have tried to remove from NAV Windows Login and SQL. And syn again.

But this message still persist.

Thank you

Comments

  • kine
    kine Member Posts: 12,562
    Look into table "Member Of" and try to filter for that user. Delete all entries. Sometime when you remove user, the assigned roles are still defined for that user, and because synchronization is working with these assignments, it can be problem...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • garak
    garak Member Posts: 3,263
    Take a look into "Member Of" and delete from there. also be sure u have deleted the users from SQL Server behind the Folder Security under the database.

    Regards
    Do you make it right, it works too!
  • cincai
    cincai Member Posts: 24
    Hi all,

    I tried your method and the error msg is not coming out anymore.

    Thank you
  • cincai
    cincai Member Posts: 24
    Hi guys,

    I encounter a strange scenario with another user where I try to remove the user login in SQL, she still can login via my Windows authentication.



    Thanks
  • kine
    kine Member Posts: 12,562
    cincai wrote:
    Hi guys,

    I encounter a strange scenario with another user where I try to remove the user login in SQL, she still can login via my Windows authentication.



    Thanks

    DB Users and WIndows logins are two different things... and if access is permitted for some group of users, in some NAV versions and configurations you do not need to have specific account for the user in NAV, group is enough to be able to login...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • gadzilla1
    gadzilla1 Member Posts: 316
    Hello all,

    I received the same error 'The database user CMAUS does not exist in the TESTDATA database'. We run NAV SQL.

    I tried the following in a test environment and I'm looking for somebody to validate whether this is a bad practice:

    -In SQL Server Management Studio, I accessed Security - Logins and right clicked on the affected user CMAUS and selected Properties
    -Under User Mapping I checked Map for the TESTDATA database with Default Schema as dbo
    -I then went into Databases - TESTDATA (the database name) - Security - Users and saw CMAUS was now a user in the TESTDATA database
    -I synchronized single user in NAV for user CMAUS and everything ran smoothly.

    So...am I way off on this? Thanks for any input! Chris

Categories