????? ?? ???????? ???????? ??? ????? ???? ???? ????? ?????? ??? ???????? ???? ???? ????? ??????? SQL Server

???? ???????: 240872 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ????? ????? ??????? ?????? ???????? ? ????????? ??? ????? ?? ?? ???????? ??? ????? ???? ???? ????? ?????? ??? ???????? ???? ???? ????? ??????? SQL Server.
???? ??? ?????? | ????? ???????

??????? ????

????? ???? ???? ????? ?????? ?? ???? ???? ?????? SQL Server ??? ???? ??? ???? ?????? SQL Server ?? ???? ??? ????? ??? ????? ????? ?????? (SIDs) ?? ??????? ?????? ?? ????? ???????? ???????? ??????????? ?? ????? ?????? ????????. ?????????? ???? SQL Server 7.0 ? SQL Server 2000 ? SQL Server 2005 ????? ?????? ?????? sp_change_users_login ????? ????? ?????????? ??? ???????. ??? ????? ?? ???? ????? ??? ??????? ??????? sp_change_users_login ????? ????? ??????? ???? SQL Server ???????? ??? ??? ????? ??? ????? ?????? ???? ?? ?? ???. ????? ?? ????????? ??? ??????? sp_change_users_login ????? ???? ??????? "sp_change_users_login" ?? SQL Server 7.0 ? SQL Server 2000 ? SQL Server 2005 ????????.

?? SQL Server 7.0 ?? ????????? ??????? ????? ???????? ????? ??? ?????? ????? ?????? ?? ????? ???????? ???????? ?????????? ?? ????? ?????? ???????? ???????? "?????? ??????". ????? ??? ??????? ?? ???????? ??? ???????? ??????? ??? ??????? ?????? ?? ????? ?????? ????????. ??? ????? ??? ??????? ????? ??????? ?????? ???????? ????? ???? ????? ?????? ?? ????? ??? ?? ???:
  • ?? ???? ????? ???? SQL Server ??? ????? ??? ?????? ?????? ????? ???????? ????? ?????? ???? ??? ??? ?? ???????? ?? ????? ????? ????? ???????:
    ????: ????? 18456, 16, ????? ?????? 1
    ??? ????? ?????? ???????? '% ls'.
  • ??? ??? ???? ????? ???? SQL Server ??? ?????? ?????? ???? ????? SID ?? ????? ???????? ???????? SID ?? ????? ?????? ????????, ???? ???????? ????? ?????? ??? SQL Server ?????; ???, ????? ????? ???????? ?????? ??? ????? ???????? ? ???????? ?? ????? ????? ????? ???????:
    ????: ????? 916 ? ??????? 14, ?????? 1 Line1
    ?????? ?????? ' %. * ls '??? ?????? ???? ?? ????? ????????' %. * ls'.
    ?????? ?? SQL Server 2005? ?? ???? ???????? ????? ????? ???????:

    ?????? ?????? '% s' ??? ?????? ???? ?? ????? ???????? '% s'. ?? ?????? ???? ?????? ??? ????? ???????? ?????.
????? ?? ????????? ??? ????? SQL Server 7.0 ?????? ???? ????? ?????? "Microsoft SQL Server 7.0 ????". ???? ???? ????? ?? ?????? ???? Microsoft ?????? ??? ?????:
http://msdn2.microsoft.com/en-us/library/Aa226173(SQL.70).aspx
(http://msdn2.microsoft.com/en-us/library/Aa226173(SQL.70).aspx)
?????? ??? ???? ?? ????????? ??? ????? SQL Server 2000 ?????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
322712
(http://support.microsoft.com/kb/322712/ )
Microsoft SQL Server 2000 ?????? S322712 ????? "?" ???? ?????????

????

  • ??? ??? ???? ?????????? ?? ?????? sysusers ???? ????? ??? ????????? ?? ??? ???? ???? ?????? ???????? ??? ?????? ????? ??? ???????? ?? ??????? ???????? ??? ????? username. objectname ??????? ?? ??? ??? ??????? sp_sidmap ??????? ?? ????? ????? ??? ?????????? ????? ????? ????? ??? ????????? ?? ??? ???? ??? ???? ?? ???? sysxlogins. ??????? ?????? ??? ??? ??????? ??? sp_sidmap ????? ??????? ?????? ?? ????? ????? ?????????? ????? ?? ???????? ?? ?????? sysusers ??? ????? ??????? ?? ???? ????? ????? ???????.
  • ?? ???? ???????? ??? ??????? ??????? ?????????. ??? ???? ????? ??????? ????????? ??????.
  • ?? ???? ????? ???? ???? SQL ????? ??? ????? ??? ???? SQL Server ???? ? ????? ????? ????? ?????? ???????? ???? ???? ?????. ?? ????? ??? ????? ???? ?????? ??? ??????? ?????? ????? ????.
  • ??? ?? ????? ?????? ?? ????? ?????? ???????? ?? ??? ???? ????? ?? ??? ???? ???? ?? ?????? sysxlogins ? ??? ???????? ???? ??????? ????? ?????? ?????? ???? ????????. ????? ??? ????? sp_sidmap ??????? ??????:
    1. ??? ???? ???????? ???? ?????? ??? ???????? ??? ????? ?????? ???????.
    2. ????? ????????? ????? ?????? ?? ????? ?????? ?? ?? ??? ???? ???????? ???? ???????? ??? ????.
  • ??? ??? ?????? ??? ????? ????? ???? ??????? ?? ????? ??? ????????? ?????? ?? ??? ???? ? ???? ????? ???? ????????. ????? ??? ??????? ??? ?? ??? ????? ????? ???????? ????? Windows ?? ?? ???????? ??? ???? SQL ??? ????? ????. ??? ?????? ????? ??? ????? ??????? sp_sidmap ????? ??? ????.
  • ??? ????? ??? ?????? ?? ??? ???? Windows ?????? ???????? ????? ?????? ??????? ??? ????? ?? ?????? sysxlogins ????? ????? ???? ????? ??? ??? ????? ???? ????? ??? ???? SQL. ?? ???? ?????? Windows ? ???? ????? ????? ?? ???? ????? ?? ?? ???? ?? ????? ?????? ?????? ??? ????? ?????? ?????? Windows.
  • ?? ???? ????? ?????? ???? ?? ?????? ?? ?????? sysusers ???? ????? ????? ?? ??? ????? ? ??? ???? ??????? ?????? ???? ??? ??? ??? ????????. ??? ??? ?????? ???? ??? ?? ?????? intervene ?????? ?? ?? ???????? ?????? ?? ????? ???? ???? ???.

    ?????? ??? ??? ?????? sysusers ?????? ???? "johndoe" ????? sysxlogins ??? ??????? ?????? ?? ????? ??? "Test\johndoe" ? "Test2\johndoe" ??? ????? ??????? ??????, ????? ???? ????? ???? ??? ?? ??? ?????????? ??? ?????? ?????? ???? ?? ???? ??? ??? "????? ??????" ?????? ????. ??? ?? ????? ??????? ???? ??? ????? ??????? ?????? ?????? ? sp_prefix_sysusersname ? ???? ??? ??????? ?? ??? ???????. ???????? ??? ???? ??? ??? ??? ?????? ???????? ?? ??? Readme.txt.

????? ??????? ?????? ???????? ? ?????????

??? ??? ????? ?????? ?? ???? ???? ?????? ???? SQL Server ??? ???? ??? ??? ????? ???? SQL Server ???? ??? ??????? ???? ???? ??????:

SQL Server 7.0 ? SQL Server 2000

  1. ???? ?? ??? ???? ????? ???? ?? ?????? sysxlogins ?? ????? ???????? ???????? ??? ?????? ?? ?????? sysusers ????? ????????.

    ?????? ?????? "????? ???? SQL Server ??????" ? ???? ??????? "sp_addlogin" ?? "??? SQL Server ???????". ?????? ????? ???? SQL Server "??????? ???? ???????"sp_grantlogin"??" ??? SQL Server ??????? ".
  2. ?? ?????? ????? MapSids.exe ?? ?? ??????? Sp_sidmap.sql ?????? Readme.txt.
  3. ????? ?????? ??? ???? ???? ?????? SQL Server ?????? ???? ?? ?? ?????? ????? Sp_sidmap.sql ?? ????? ?????? ????????. ????? ??? Sp_sidmap.sql ????? ????????? ??????? ????? sp_sidmap ? sp_prefix_sysusersname.
  4. ???? ?? ?? ????? ???????? ?? ??? ?????? ??? ?????? ?? ?????? ??? ?? ??? ???? ?????? ????????? ???????.
  5. ???? ?? ?? "???? ???????" ???? ??????? ?? ????? ?? ?????? ??? ????? ??????. ?????? ????? ???? ??? CTRL ^ T ??????, ?? ???? ??? ????????? ?? ???? ??? ????? ?? ????. ??? ??? ???? ?????? ?? ??? ??????? ????? ??????? ?? ???? ???? ??? ??????? ??? ??? ???. ?? ????? ??? ??? ????? ???? ??? ??? ?? ??? ?? ??????.
  6. ???? ?? ??????? ???? ???? ??? ??????? sp_sidmap ????? ???? ?? ???? ?????? ?? ?? ??? ??? ??? ????? ???????? ???? ????: 
    EXEC sp_SidMap @old_domain = old_domain_name,
@new_domain = new_domain_name,
@old_server = old_server_name,
@new_server = new_server_name
    ??????? ??? ????? ?????? ??????? ???????? ?????? ?????? ???? ?????.
  7. ??? ??????? ?? ??? ????? ????????? ???????? ?? ??? Readme.txt.

    ?????? ??? ????? ??? ????????? ??????? ???? sysusers ?? ?????? ?????? ???? ????? ?? ????? ????????. ?????? ??? ???? ??? ????? ??? ????? ??????? ????? ???????? ?? ?????? ?????????? ?? ??? ???? ????? ????????.

SQL Server 2005

??? ??? ???? ?????? SQL Server 2005 ??????? ???? WITH ????? ?????? ?? ????? ALTER USER remap ?????? ?????? ???? ?????. ????? ?? ?????????? ?? ?????? ???? ???? ????? Microsoft (MSDN) ?????? ??? ?????:
http://msdn.microsoft.com/en-us/library/ms176060.aspx
(http://msdn.microsoft.com/en-us/library/ms176060.aspx)
?????? ???????? ???? WITH ????? ?????? ?? ????? ALTER USER ??? ????? SQL Server 2005 ?????? ????? ?????? SP2.
???? ??? ?????? | ????? ???????

?????

????? ?? ?????????? ???? ??? ????? ???????? ??????? ?????? ?? "????? ??????? ?? Microsoft:
274188
(http://support.microsoft.com/kb/274188/ )
"??????? ????? ???????? ?????????? ???????" ????? ?? ???????? ??? ?????
246133
(http://support.microsoft.com/kb/246133/ )
????? ??? ?????? ????? ?????? ?????? ?????? ??? ?????? SQL Server
168001
(http://support.microsoft.com/kb/168001/ )
????? ????? ?????? ?/?? ??? ???????? ??? ??????? ?????
298897
(http://support.microsoft.com/kb/298897/ )
?????: ????? Mapsids.exe ????? SIDs ??? ???????? "?" ????? ?????? ???????? ????? ??? ??? ????? ????????
???? ??? ?????? | ????? ???????

???????

???? ???????: 240872 - ????? ??? ??????: 01/???/1430 - ??????: 8.0
????? ???
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 64-bit Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Workgroup Edition
????? ??????: 
kbmt kbhowtomaster KB240872 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????240872
(http://support.microsoft.com/kb/240872/en-us/ )
???? ??? ?????? | ????? ???????

????? ???????

 
???? ??? ?????????? ??? ??????