[SQL] Navision error user ID can't change

 Navision can get an error with a user ID message. 

Then you need to check Navision SQL. 

In Navision SQL, the user ID should have master DB access but if you don't have it. then use the below SQL code.

USE master

EXEC sp_change_users_login 'AUTO_FIX', 'user ID'

example ) 

USE master

EXEC sp_change_users_login 'AUTO_FIX', 'T189943'

result 

row for user 'XXXX' will be fixed by updating its login link to an existing login.

The number of orphaned users fixed by updating users was 1.

The number of orphaned users fixed by adding new logins and then updating users was 0.

The user's DB access will be fixed. And the user ID is updated. If you see the result with 0 to select then your Navision DB might need to check this also. 

Check your SQL in Security-Logins, ensure the user ID is there, and check Property to have this "User Mapping" for the Database. It needs your master DB and Navision DB. 

After you see the password is not matched error to Navision login then you need to update Navision DB to match as below. 

Tools - Security - Database Logins -Select a user that has a password issue

Tool - Security - Synchronize Single Login (This will update the user password with SQL)