User Synchronization Error

cincai

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

kine

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...

garak

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

cincai

Hi all,

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

Thank you

cincai

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

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...

gadzilla1

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