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

?????? ????????? ?????? ?????????
???? ???????: 321247 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

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

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

???? ??????

?? ???? ??? SQL Server ?? ???? ???? Microsoft ??????? ???? ???? ??? ????? ????? SQL Server. ??? ??????? ???? ???? ??? ??? ???? ?? ????? ???? SQL ?????? ????? ?????? ??? Windows Clustering. ???? ???? ???? ????? ??????? ?????? ?? ???? ?? ??????? ???? ??????. ??? ???? ?? ?? ????? ?? ??? ????? SQL ??? ???? ???? ??? ??? ???? SQL ????? ??? ???? ?? ?????? ???.

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

????? ??????? SQL Server ???? ??? ???? ???? ????? ????? ??????. ?? ?????? ??? ???? ?????? ??????? ?? ??? ????? SQL Server ?? ?????? ?? ???? ????? SQL Server ???????? ????? "?????" ? ????? ??????? ???? ???????? ???? ???????. ?? ???? ???????? ??? ?? ???? ??? ???? ????? ????????? ???? ???? ?????? ????? ?? ??? SQL Server ???? ???? ??????? ???? ?? ??? ???? ?????? ? ???????? ???????? ????? ??????. ???????? ??? ???? ????? ???? ????? SQL Server ??????? ?? ????????? ??????, ??? ????? ???? ?????? ????????? ??? ??? ?????? (???? ???? ???? SQL ?? ??? ????? ??????) ???? ??? ???? ??????. ??? ?? ????? ?????? ??? ????????? ?????? ????? ?? ?????? ????? ?????? ?????? ???????? ?? ??? ??????? SQL Server ? ???? ?????? ?????.

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

????? ????? ????? SQL Server ???? ??? ???? "?????? ??????". ?? ???? ????? ???? ???? ???? LocalSystem ?? ??? ??? ??????? ?????? ??????? ??????. ??? ?????? ??????? ??? ????????? ??? ????, ??? ?? ???? ?? ???? ???? ?????? ???? ?????? ????? SQL Server ???????. ??? ?? ????? ?? ?????? "???? ???? ??????? ???????", ?? ????? ??????? ???? ???????? ?????? ??? ??? ????? SQL Server ??? ?????? LocalSystem ??? ?????? ????? ???? ?????? LocalSystem ??? ????? ??????? ??????. ??? ???? SQL ??? ??? ?????? ??? ??? ?????? ??? ????? ???? ??????? ?????? ???????? ????? ?????? ?????? ??? ?????.

?????? ??? ??????? ??? ???? ???? ?????? ??????? ???? ???? ????? ???? ????? SQL Server ? SQL Server ???? ??????? ????? ??? ??????? ?????? ?? "??? SQL Server ???????":
Setting up Windows Service Accounts

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

???? ?????? ?????? ???? ????, ?? ????? ??? ???? ?????? ???? ??? ????? Microsoft ?? SQL Server 2000. ??? ????? ????? ???? ??? ? ??? ??????? ??? ?????? syslogins ?? ????? ?????? MASTER. ??? ????? ?????? ????? ?????? ??? ????? ?????? ??? ????? ?????? ??? ??? ??????? ??? ?????? sysusers ?? ????? ????????. ??? ??????? ??? syslogins ????? sysusers ??? ??? SID.

??? ?? ??? ????? ?????? ?????? ??? ???? ???, ??? SID ??? ????? ?? ???? ???????. ????? ??? ???? ????? ???????? ????? ?? ??? ????? ?????? ????? ?????? ??? ???? ?????? ???? ??? SID ?? ??? ?? ??? ????? ?????? ???? ????? ??? SID ??? ???????.

?????? ??? ??????? ??????? ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
240872INF: ????? ?? ??????? ??? ????? ??? ??? ????? ??????

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

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

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

????? ?????? ???? ??????? ???? ?? ?????? ???????? ????? ?????????? ??? ????????? ?? ???? ???? ?????? ???????/????? ?????? ??? SQL Server ???? ?? ????? ????? (??? ???? ????? ?? ?????? ?? ??? ??? ?????).

??? ?? ??? ????? ?????? ???? ??????? ???? ?? ?????? ???????? ????? ?????????? ??? ????????? ?? ???? ???? ?????? ???????/????? ?????? ??? SQL Server ???? ?? ????? ??????? ??? ???? ??????? ????? ??? ?????. ??? ?????? ??? ??? ???????? ?????? ???? "???" ??? ???? ????? ???? ????? ?????????? ??? ???????? ??? ???? ???? ??? ???? ??????? ???????. ???? ????? ?? ????? ??? ????? ?????????? ?? ?????? ??????.

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

??? ??? ????? ????????? ???? ???? ????? ??????? SQL Server ?? ???? multi-domain ? ???? Microsoft ????? ?????? ????? ?????? ??????? ??? ???? ???????? ???????? ?? ????? ?????. ??? ???? ??? ?? ????? ?? ????? ?????? ????? ??? ???????? ????? ??????? ???? ???????? ?????? ????? ?????. ?????? ??? ????? ?? ??? ??????? ?????? ???? ??? ??????? ?????? ???? ???? LocalSystem ??????? ???????? ?? SQL Server.

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

????? ????? ?????? Windows ?? ?????? SQL (?????? ?????? ???????? ?????????) ??????? ????? ???? ????? ? ????? ??????? ???? ?????. ????? ????? ??? ??? ????? ??????? ????? ????? ??? ?? ??? ????? ????? ??? ??? ????????. ???? ???????? ?????? ???? SQL ?????? Windows; ??? ???? ??? ???? ?????? SQL? ??? ????? ????? ???? SQL ???? log_shipping_monitor_probe ??? ??????? ???????, ?? ??? ???? ?????? ???? ????? ??? ??? ????. ??? ???? ?????? SQL? ???? ????? ????? SQL Server ???????? ?????? ?????? SQL ? Windows.

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

?? ???? ????? ????? ???????? ???????? ?? ??? ????????? "? ????? ?????? ??? ????? ???????? ??? ?? ???? ??????? ???. ?? ???? ??????? ????? ???????? ???????? ?? ??? ?????, ???? ?? ???? ??? ???? ???? ?????? ?????? ??? ????? ???????? offloading ??? ????? ?? ?????? ???????. ??? ???? ?????? ????????? ???? ????? ??????? ??? ?? ????? ??? ????? ??? ??????? ?????? ??? ?????? ???????. ??? ????? ???????? ?? ???? ????????? ?? ????? ????? ??? ??????? ??? ???? ????? ??????. ?? ??? ??????? ??? ????? ???? ?????? ????? ?????? ??? SQL Server ???? ??? SID ??? ???? ?????. ????? ??????? ???? Windows ???????? SIDs ??? ??? ?????? ? GUID Windows ??? ??? ??????? ?????? ??????.

?????? ??? ??????? ?????? ??? ????? ????? ??????? ???? SQL ?? SID ????? ??? ?????? ?????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
303722????? ??? ?????? ??? Logins SQL ??? ??????? ????? ???????? ??? "?????" ???????? ?????

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

????? ??????? ????? ????? ????? ????? ??? ????? ???? ????? ???? ??? ???? ???????. ????? ?????? ???? ?? ?? ???? ?????? ??????? ??? ??? ??????. ???? ?? ????? ????? ???? ????? ????????? ??????? ???? ??? ???????. ????? ??? ??? ????????? ??????? sp_resolve_logins ?????? ??? SID ??????? ?????? ???? ???? ?? ????? ???????? ????????? ??? ??? ?? ??? ????? ?????? ????????? ???? ????? ???????? ????????.

??? ????? ??? .bcp ?? ???? syslogins ?? ?????? ??????? ??????? ???? ?? ??? ??????? ?????? ??? ???? ????. ?? ??? ?????? ?? ????? ?????? ?? ??? ?????? ?????? ?????? syslogins ?? ????? ?????? MASTER ???? ????? ????? sysusers ????? ???????? ????????. ?????? ?????? ??? ???? ???? ????? ??? ????? ???? ???? ????? ?? ???? syslogins ? SID ??? ??? ??? ???????? ?? ?????? sysusers ????? ???????? ???????? ????? SID (?? ????? ???????? ????????) ???????? sp_change_users_login ??????? ???? ??? ?? ???? syslogins.

????? ????? ?????? ???????? ??? ??????? ?????? ???????:
  • ??? ????? ??????? ???? SQL ?????? ??? ???? ?????. ?????? ????? ??????? ?????? ??? DTS Logins (???? ??? ????? ?? ????? ??? SQL Server ??????? "????? ????? ??? ????? ????? ????? ??????."
  • ??? ???? ????? ??? .bcp ?? ???? syslogins ?? ?????? ???????. ??? ?? ???? ??? ????? ?????? ???? ?? ???? ??? ????? ????? ?? sp_resolve_logins ??? ????? ??? ??????? ??????.
??? ?? ????? ?????? ??????? ??????? ??? ?? ???? sp_resolve_logins ?????? ????? ??? ??????? ?????? ?? ????? ???????? ????????:
  1. ??? ?? ????? ??? ????? ?????? ?? ??? .bcp ?????? syslogins ????? ?? ?????? syslogins ?? ?????? ???????.
  2. ??? ?? ????? ???? SID ??? ????? ?????? ??? .bcp ??????? sysusers ?? ????? ???????? ????????
  3. ??? ?? ???? ???? SID ?? ????? ???????? ??????? ??????? ?? ?????? SID ?? ?????? syslogins ?? ????? ?????? MASTER ??? ???? ?????.
??? ??? ?????? ??????? ???? SQL Server ??? ?? ???? ?? Q303722 ?? ??? ????? ??? ??????? ?????? ???? ??? ?????? ???? ???? ?????? ????? ?????? ?????? ???? ?????? SID ?? ???? syslogins (?? ????? ?????? MASTER ??? ???? ?????) ????? sysusers (?? ????? ???????? ????????).

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

????: ?? ????? ??? ??? ???????? ??????? ????????? ??? ???? ????? ???????? ?

???????: ???. ??? ???? ????????? ??? ????? ?????? ?????? ????? ? ??? ?? ????? ??? ???? ??????? (?? ?????) ????????.

????: ???? ???? ??????? ?????? ????? ??? ???? ????? ?? SID ??? ? ????? ??? ??? ???? ??????? ??? ????????? SQL Server ?????? ??? ??? ????? ?????? ????????? ?? ??? ??????.

???????: ??. ?? ???? ???? ???? SQL Server ?????? ??????? ?????? ????? ?? SID ?????. ??? ??? ???? ????? ??? SID ????? ??????? ??? ????? ?? ?????? ??????, ??????? ??????? ??? ????? ????? ?????? ??????? ??? ?????? ??????? ?? ????? ?? SID ??? ????? ??? ???? ?????.
?????? ??? ??????? ?????? ??? ??? ????? ????? ????? ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
314515INF: ????? ??? - SQL Server 2000 - ??????? ?????????

???????

???? ???????: 321247 - ????? ??? ??????: 19/?? ??????/1426 - ??????: 3.5
????? ???
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 64-bit Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Workgroup Edition
????? ??????: 
kbmt kbhowtomaster KB321247 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????321247

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

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com