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 ...
My information note