MS-SQL Fixing Orphaned Users

Fixing Orphaned Users

Report ueber Orphaned Users

EXEC sp_change_users_login 'REPORT' 

UserName UserSID 
-------- ----------------------------------- 
user1    0xB675848D3CC91D56932769131728CF1E
user2    0xC675848D3CC91D56932769131728CF1F
user3    0xD675848D3CC91D56932769131728CF1A

Reconnecting a User DB User<->SQL Login

EXEC sp_change_users_login 'UPDATE_ONE','user1','user1'