Änderungen
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 ===
<pre>EXEC sp_change_users_login 'REPORT'
UserName UserSID
-------- -----------------------------------
user1 0xB675848D3CC91D56932769131728CF1E
user2 0xC675848D3CC91D56932769131728CF1F
user3 0xD675848D3CC91D56932769131728CF1A</pre>
=== Reconnecting a User DB User<->SQL Login ===
EXEC sp_change_users_login 'UPDATE_ONE','user1','user1'
=== Report ueber Orphaned Users ===
<pre>EXEC sp_change_users_login 'REPORT'
UserName UserSID
-------- -----------------------------------
user1 0xB675848D3CC91D56932769131728CF1E
user2 0xC675848D3CC91D56932769131728CF1F
user3 0xD675848D3CC91D56932769131728CF1A</pre>
=== Reconnecting a User DB User<->SQL Login ===
EXEC sp_change_users_login 'UPDATE_ONE','user1','user1'