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'