MS-SQL Fixing Orphaned Users
Aus Software Entwicklung Projekte
Version vom 13. Januar 2016, 12:18 Uhr von David (Diskussion | Beiträge) (Die Seite wurde neu angelegt: „== Fixing Orphaned Users == === Report ueber Orphaned Users === <pre>EXEC sp_change_users_login 'REPORT' UserName UserSID -------- -----------------------…“)
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'
