??? ???? ??? ?????? ??? ??????? ??? ?? SQL Server 2005 ?????? ????? ???? ??????? ?? ???????

?????? ????????? ?????? ?????????
???? ???????: 932881 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

????? ???

?????? ????? Microsoft SQL Server 2005 ?????? ?????? Windows ???? ??? ???? ?????. ???? ?????? ????? SQL Server 2005 ???? ?????? ??? ???? ?? ????? ??? ?????? ????? ??. ?????? ??? ????? ???? ?????? ????? ??? SQL Server ??? ??????? ??????? ???? Windows ???? ???????. ??? ????? ??????? ?????? ??? ?? ??? ????? ???? ??? ????? ?????? ????? SQL Server 2005. ???? ?????? Windows NT ????????? ???????? ?? ??? ???? ????? ??? ????? ?????? ????? ?????? ??????? ?????? (SACL) ??? ?? ?????? Windows. ?? ???? ????? ?????? ???????? ?????? ??? ???? ??????.

???????? ??? ???? ??? ??? ??????? Windows ???? ??? ???????? ?? SQL Server 2005 ????? SQL Server ? ??????? BUILTIN\Administrators ??????? ???? SQL Server 2005 ???? ??? ??????? ?? ??? ???? ???? SQL Server 2005 SYSADMIN. ???? ??? ??????? ?? ?????? ?? ???? ???? ????? ?? ??? ????????? ?????? ?????? ??? SQL Server 2005 ???????? ????? ?????? Windows NT. ???? ???????? ?? ????? ?????? ?? ??? ???? ???? SQL Server SYSADMIN ????? ???????? ?? SQL Server 2005 ?????? ????? SQL Server 2005. (???????? ??? ????? ?????? ???????? ???? sa). ?? ???????? ???? ???? ??? ???? ??? ????? SQL Server 2005 ? ???????? ?????? ??. ?????? ???? ???????? ???? ???? ???? ?????? ????? SQL Server 2005 ?? ???? ???? SQL Server ???? ???? ??????? ?????? ????? ?????? ??? ?????????. ?? ???? ???????? ????? ????? ?????? Windows NT ?? SQL Server 2005 ?????? SQL Server.

??? ????? ??? ??????? Windows ???? ??? ???????? ?? SQL Server 2005 ??????? ????? (SSRS) "?" ???? ????? ?? ?? ???? ??????? ???? SQL Server. ??? ???? ????? ???????? "?" ???? ????? ?? ?? ???? ??? ?? ????? ?? ??? ????? ?????? ?????? ?????.

????? ??? ????????? SQL Server 2005 ??????? ???????? ?? ????? ????? ???????? "?" ????? ???? ??????? ?? ???? ?????? ?????. ???? ????????? ?? ??? ??????? SQL Server 2005 ?? ?????? ??? ??????? ??? ?? ??? ????? ???? ???????.

??????? ????

??? ???? ??? ?????? ??? ??????? ??? ?? SQL Server 2005 ?????? ????? ???? ??????? ?? ???????

???? ?????? ??? ??????? ??? ??? SQL Server 2005 ?????? ????? ???? ??????? ???? ????? ? ??? ???? ????? ???????? ????? ?????? ???? ???? ?????? ???????? BUILTIN\Administrators. ??? ??? ??? ??????? ?????? ?????? ??? ?????? ?????? ?? SQL Server 2005 ??? ??? ???? ???? SQL. ??? ???? ??? ????? ?????? ????? ?????? ?? ??? ????? ?????? ?????? ?????. ???????? ??? ??? ??????? ?????? ???? ?? ????? ??? ??????? Windows ????? ???. ?????? ????? ???? ??????? ???????:
  1. ???? ?? ?? ???? ???? ???? ????? ??? ????? ?????? ?????? ?????. ??? ??? ??? ?????? ??? ????? ???? SQL Server 2005 ??? ?? ???? ????? ?????? BUILTIN\Administrators ???.
  2. ????? ???????? ????? ?????? ???? ???? ?????? ???????? BUILTIN\Administrators. ?????? ????? ???? ??????? ???????:
    1. ?? ?????? ?????? ??? SQL Server 2005 ???????? ???? ?????? ?? ??? ALTER ??? ????? ??????.
    2. ?? ?????? ?????? ????? Logins ???? ??? ?????? ?????? ??? BUILTIN\Administrators ??? ?? ???? ??? ???.
    3. ?? ???? ?????? ??? ???? ???? ??? "?????".
    ?????? ??? ??? ????? ?????? ???? ?? ????? ??? ???????? BUILTIN\Administrators ?? ???? ????? ??? ??? ????? ??? ???????? ????? ?????? ??? SQL Server 2005 ?? ?????? ??? ?????? ??? SQL Server 2005.

    ?????? ??? ??????? ??? ???? ???? ???? ???? ???????? ?? Microsoft "(MSCS) ? ???? ???"???? ???? ???? ???? ???????? Microsoft (MSCS)".
  3. ??????? ???? ???? ??? ALTER ????? ?????? ??? ???? ??????? ???? SQL Server 2005 ?????? ??? ?????? ?????? ???? ??? ????????? ?????? SQL Server 2005 ???? ???? SQL ???? ????. ?????? ????? ?? ?????? ????? SQL ???????.
    CREATE LOGIN [<Domain Name>\<SQL Server Service Account>] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
    CREATE LOGIN [<Domain Name >\<SQL Server Agent Service Account>] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
    
  4. ??????? ???? ???? ????? ?? ????? ?????? SYSADMIN ????? ??? ???? ????? ?????? ????? ?????? ???? ??? ??????? ?? ?????? 2 ?? ????? ?????? SYSADMIN ????? ??? ????.
    EXEC master..sp_addsrvrolemember @loginame = N'<Domain Name>\<SQL Server Service Account> ', @rolename = N'sysadmin'
    EXEC master..sp_addsrvrolemember @loginame = N'<Domain Name>\<SQL Server Agent Service Account> ', @rolename = N'sysadmin'
    
  5. ??????? ???? ???? ??? ALTER ??? ????? ?????? ??? ??? ??????? ?????? ???? ?? ????? ??? ???????? SQL Server 2005 ? ?????? Windows ???? ???? SQL.
    DROP LOGIN [<Computer Name>\<SQLServer2005SQLServerUser>$<Computer Name>$MSSQLSERVER]
    DROP LOGIN [<Computer Name>\<SQLServer2005AgentUser>$<Computer Name>$MSSQLSERVER]
    
??? ??? ????? ??? ???????? ???? ?????? ?????? ??? ???? ???? SQL Server 2005 ???????? ??? ???? ???? SQL Server ???? ??? ?? ??? ???????? ????? ?? ????? ???? ???????. ??? ??? ???? ???? MSCS ????? ?? ???????? SYSADMIN ???? ??? ???? ???? ???? ???? ???? MSCS ??? ????? ?? ???????? ????? ?? ????? ???? ???????. ??? ??? ???? ????? ???? ??????? ???? ???? ???? ???? SQL Server 2005 ?? ???? ???? SQL Server ???? ? ???? ?? ?????? ????? ???? ??????? ???? ???? ????? ?????? ??? ???????. ??? ????? ???? ??????? ?????? ?????? ??? ????????? ???? ??????? ????? ???? ??????? ??? ???? SQL Server 2005 ?????? SQL Server.

???????? ????? ???? ??????? ?? ?????? ???????? ???? ?????? ?????? ???? ??? ????????? ?????? SQL Server 2005 ???? ???? SQL ??? ?? ???? ????? ???? SQL Server ?????? ??? ????? ???? ???? ????? ????? ??????. ????? ???? SQL Server 2005 ?? ???? ???????? ??? ????? ???? ???????. ????? ??? ????? ?????? ?????? ??? ??? ?????? ??? ???????. ??? ???? ??????? ????? ????? ???? ??????? ??? ???? ???? ?? ?????? ????? ???? SQL Server 2005 ????? ????? ?????? ??????? ??????? ???? ??? ????????? ?????? SQL Server 2005. ?? ???? Microsoft ?????? ??? ??????.

???? ???? ???? ???? ???????? ?? Microsoft "(MSCS)

?? ????? ????? ???? ?????? ????? ??? SQL Server 2005 ????? ???? ???? MSCS ??? ??????? ?? ?????? BUILTIN\Administrators ?????? ?????? ??? SQL Server 2005 ?????? ???????? IsAlive. ??? ??? ?????? ???????? BUILTIN\Administrators ?? ???? ?????? ????? ??? ??? ??? ?????? ???? ?????? MSCS ?????? ?????? ??? ???? ?????? ????? ??? SQL Server 2005 ???? ????. ?????? ????? ?? ?????? ????? SQL ??????? ?? ???? SQL Server 2005.
CREATE LOGIN [<Domain Name>\<MSCS Service Account>] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
SQL Server 2005 ?????? ????? ?????? SP2 ????? ??????? ??????? ??????? ???? ????? ??? SQL Server 2005. ???????? ??????? ?????? ???? ???? ???? ???????? SQL Server 2005 ???????? ??? ???? ???? ????????. ???? SQL Server 2005 ??????? ????? ???????? ?????? (DLL) ????? ?????? ??????? ??? ???? ? ??? ???:
  • ???? ?????? ?? SQL Server 2005 ???? ?????? ???????? Sqlcmd.exe ??? ???? ?????? ????? ???? MSCS. ??? ?????? SQL Server 2005 ????? ?????? ??? SQL ??? ????? ????? ???? (DAC) ????? ??? ????? ???????? ????? ??????? (DMV).
  • ????? ?????? SQL Server 2005 ??? ????? ?????? ?? ????? SQL Server 2005 ??? ???? ???? ????????.
???? ?????? ????? ????? ???? ?? ????? ?????? ??????? ??? ? ??? ?? ??? ????? ???? ???? MSCS ?? ??? ????? ?????? ?????? ?????. ??? ??? ???? ??????? ?????? ?? ??????? ?????? ?? ?? ???? ????? ???? ???? MSCS ?? SYSADMIN ???? ??? ????, ???? ??? ???? ???? MSCS ????? ???? SQL Server ???? ?? ??? ????? ?? ????? ?????? SYSADMIN ????? ??? ????. ?? ??? ?????????? ????? ??????? ???? ??? ???????? ????? ?????? ?????? ???????? Sqlcmd.exe ??? ?????? ???????? Sqlcmd.exe ????? ????? ?????? ??? SQL Server 2005. ????? SQL Server 2005 ??? ?? ???? ?????? ??? ????? ??? ????? ?????? ??? ????? ?? ?? ??? ??? ???? ???? SQL Server 2005 ?????? ????? DLL ?? ????? ?????? SYSADMIN ????? ??? ???? DLL.

??? ??? ???? ????? ?????? ??? SQL Server 2005 ???????? ???? ???? ????? ?? ????? ?????? SYSADMIN ???? ??? ????. ?? ?? ?????? ????? SQL ??????? ?????? ???? ???? MSCS ??? ??? ???? ???? SYSADMIN.
EXEC master.sp_addsrvrolemember @loginame = N'<Domain Name>\<MSCS Service Account> ', @rolename = N'sysadmin'

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

??? ????? ?? ??????? ??????? ?? ???? ????? ???? ????? ??? ????? ???? ??????? ??????? ?? SQL Server 2005 ? ??????? ??????? ????? ???? cumbersome ????? ?????? ?????? ?? SQL Server 2005 ???? ???? SQL. ?????? ?????? ?????? ?? SQL Server 2005 ? SQL Server ???? ???? ??????? ???????:
  1. ????? ???? ???? ???? ?? ?????? ?????? ??? ?????? Windows ?? ????????? ???? ??? ???????? ?? SQL Server ? ????? ???? SQL.
  2. ??????? ???? ???? ??? ALTER ????? ?????? ??? ????? ????? ???? SQL Server 2005 ??????? ???? ?????. ?????? ????? ?? ?????? ????? SQL ??????? ?? ???? ?? ????? ALTER ????? ?????? ???.
    CREATE LOGIN [<Domain Name>\<New SQL Server Service Account>] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
    CREATE LOGIN [<Domain Name>\<New SQL Server Agent Service Account>] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
    
  3. ??????? ???? ??? ????? ?? ??? ???? ???? SYSADMIN ????? ????? SQL ???????.
    EXEC master..sp_addsrvrolemember @loginame = N? <Domain Name>\<New SQL Server Service Account> ', @rolename = N'sysadmin'
    EXEC master..sp_addsrvrolemember @loginame = N? <Domain Name>\<New SQL Server Agent Service Account> ', @rolename = N'sysadmin'
    
    ?????? ??? ??????? ????? ???? ???? SQL Server 2005 "?" ???? ???? SQL Server ???? ??? ??? ???? ???? ????? ??????.
  4. ????? ???? ???? ???? ??????? ???????? ????? ????? SQL Server. ?????? ????? ???? ??????? ???????:
    1. ?? "????? ????? ???? SQL" ? ???? ??? SQL Server 2005 Services.
    2. ???? ??? ?????? ?????? ??? ?????? ???? ???? ??????? ?? ???? ??? ?????.
    3. ???? ??? ????? ??????? ????? ?????? ?? ?? ?????? ??????? ???? ???????? ????? ??? ??????? ??????.
    4. ???? ??? "?????" ??? ???????? ?? ????? ??????? ??????.
    ?????? ??? ????? ???? ???? ????? ????? SQL Server ???? ??? ????? ????? ??????.
  5. ??????? ???? ???? ??? ALTER ??? ????? ?????? ???? ??????? ?????? ???? ?? ????????? ?????? ???? ???? SQL Server 2005 ???? ???? SQL Server ????. ?????? ????? ?? ?????? ????? SQL ???????.
    DROP LOGIN [<Domain Name>\<Old SQL Server Service Account>]
    DROP LOGIN [<Domain Name>\<Old SQL Server Agent Service Account>]
    
?????? ??? ???? ???? ???????? ??? ?????? ???? ????? ?? ???? Windows NT ????? ?? ???? ????? ?????? ???? ????? ??? ??????? Windows ?????? ??? ?? ?????? 1.

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

??? ??? ???? ????? ???? SQL ?? ?????? ??? ??????? ???? ?????? ?????? ?????? ??????? ??? ????? ????? ???????? ???????:
  • ????? ???? ????? ????? ?????? ????? ????? ??? Windows.
  • ????? ??? ??????? ????? SQL Server 2005 ? ????? SQL Server ????.
  • ????? ?????? ??? ????? ????? ?? SQL Server ???? ????? ????? ???????? ???????? ???????? ????? ??? ????? ?????? ????? ????? ?????????.
  • ????? ??????? ??? ???? ???? SQL Server 2005 ?? ???? ???? SQL Server ????.
  • ????? ??????? ???? ???? ??????? "?" ??????? ???? ????????? ?????? ???? ???? SQL Server 2005 ?? ???? ???? ???? SQL Server ???? ?? ?? ???? ???? ???? MSCS.

???? NT AUTHORITY\SYSTEM

??? ????? ??? ???? NT AUTHORITY\SYSTEM ????? ???? SQL Server. ??? ????? ???? NT AUTHORITY\SYSTEM ?? ??? ????? ?????? ?????? ?????. ?? ??? ??? ?????? ?? ??????? ?? ??? ?????? ???? ????? ??????. ??? ??????? ?????? NTAUTHORITY\SYSTEM ?????? Microsoft Update ??? ??? Microsoft SMS ?????? ??? ?????? ?????????? ??????? ??? ????? SQL Server 2005. ??? ????? ??????? ?????? NTAUTHORITY\SYSTEM ?????? ???? ???? SQL.

?????? ??? ????? SQL Server 2005 ?? ??? ???????? ?????? ??? ?????? ???? ??????? ?? ?????? BUILTIN\Administrators ???? ??????? SQL Server 2005 ?????? SQL Server. ???? ??????? ???????? ??? ????? ?? ?? ??? ???? ???????? BUILTIN\Administrators ?? ??? ????? ???? ???? ???? ??? ????? ?? SYSADMIN ???? ??? ????. ????? ??? ?????? ??? ???????. ????? ?? ??? ?????? ?? ????????? ?? ??? ????? ??????? ????????? ????????.

?????? ??? ???? ?? ????????? ??? ???? ???? ????????? ?? SQL Server 2005 ???? ??????? "???? ???????? ?????? ??? SQL Server ?????" ?? SQL Server 2005 ????????.

?????

????? ?? ????????? ??? ???????? ?????? ?????? ????? SQL Server ?? ?????? ???? Microsoft TechNet ??? ??? ??????:
http://technet.microsoft.com/en-us/library/ms144228.aspx

???????

???? ???????: 932881 - ????? ??? ??????: 18/???/1430 - ??????: 3.1
????? ???
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
????? ??????: 
kbmt kbpubtypekc kbcode kbinfo kbhowto KB932881 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????932881

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

 

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