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

???? ???????: 283811 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
????? ???? | ?? ????

?? ??? ??????

??????

??? ????? Microsoft SQL Server ????? ??? ???? Microsoft Windows NT ???? ??? ??????? SQL Server ?? Windows NT ??? ?????? ???????? Windows ???? ???????? ??????? ??? ??? ??????? ????????? ??????? ???????. ??? ??? ?????? ?????? ???? ??? ??????? ?? SQL Server (???? MSSQLServer) ? ???? SQL Server ???? ???????? ????? ??????? ???? SQL (SEM) "??" ????? ????? ???? SQL (SSCM) ? ????? SEM ???????? ???? ???????? ???????? ? Windows ???? ???????? ?????? ??? ??????? ?????? ?? ???? ?? ???? ?????? ??? ??? ???. ?? ???????? ??????? ??? ?? ??????? ?????? ???? ????.

?????? ??? ?? ???? ???? ???? ??????? ??? ???? ???? ?? ??? ??? ??????? ?????? ???? "????? ??????? ???? SQL.

??? ???? ?? ???? ??????? ????? ??????? ???????? ?? ?? "???? ??????" ?? ?? ????? ?????? ?????? ??????? ???? ??? ??????? MSSQLServer ?????? ?? ???? SQL Server ???? ???? ?????? ?????? ????? ???????? ??? ???? ?????.

?????? ??? ??????? ??????? ???? ??? ??????? ??? ????? ??????? ???? ??? ??????? ???????? ????? ??????? ????????.

??? ?????? ? ?????? ????? Microsoft ??????? ??? ????? ? ??????? ?? "????? ??????? ?? Microsoft: ???? ???? Microsoft ??? MS02-038
http://www.microsoft.com/technet/security/bulletin/MS02-038.mspx
(http://www.microsoft.com/technet/security/bulletin/MS02-038.mspx)


???? ???? Microsoft ??? MS02-034
http://www.microsoft.com/technet/security/bulletin/MS02-034.mspx
(http://www.microsoft.com/technet/security/bulletin/MS02-034.mspx)
FIX 322853
(http://support.microsoft.com/kb/322853/ )
: SQL Server ???? ?????? ??? ???????? ?? ??????? ??????? ??? ????? ????? ??? ???? ?????
?????? ???? ??????? ?????? ?MS02- 034 ? ??? MS02-038 ????? ????? ??? ????? ??? ????? ?????? ???????? ???????? ???????? ??? ????? ??? ??? ??? ??????????.

????? SQL Server ?? ???? ???? ???? ???? SQL ???????? ??????? ???????? "????? ????? ?? ??????? ????? ??????? SQL ?? Studio ????? ???? SQL

??? ??? ?????? ???? ???? ???? SQL ?? ???? ???? ???? ???? SQL ???????? ??????? ???????? "????? ????? ?? ??????? SEM ?? SSCM ???? ????? ?? ??? ??????? ?NTFS ?????? ???????? ????? Microsoft Windows ???????? ???? ??? ????? ?????. ??? ?? ???? true ?? SQL Server Desktop Engine (??????? ????? ???? MSDE 2000) ?? ?????? ????? SQL Server 2005 Express Edition ???? ??? ???? SEM ?? SSCM ???? ???????? ?????? ????????? ????????. ???? ????? ????? ????? ??? ?? ??????? ???:
  • ?????? ???????.
  • ?????? ???? ????? NTFS ??? ?????.
  • ???? ?????? Windows.
??? ??????? ?? ???? ???? ????? ?? ??????? ???????.

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

????? ?????? ?????? ???? ??? ??????? ?? ??? ???? MSSQLServer ????? SQLServerAgent (??? ???? Microsoft Windows NT ???? ?? ???? ???? Windows NT) ??? ?????? ??????? ???????? ?? ??????? ???????. ??? ????? ??????? ?????? ?? ?? ??? ??????? ?? ???????? ??? "????? ???? ??????" (ACLs) ??? ?????. ???????? ???? ??? ?????? ??? ?? ???? ?? ??????.

??? ????? ??? ?????? ?????? ??? ???? ???????? ??????? ????????? ???????:
  • ????? ?????:
    HKEY_LOCAL_MACHINE\Software\Clients\Mail

    Server\80 SQL HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft

    Server\ SQL HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft <Instancename >
  • ?????? ???????:
    HKEY_LOCAL_MACHINE\Software\Clients\Mail

    Server\80 SQL HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft

    HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Cluster

    HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\MSSQLServer

    HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Providers

    HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Replication

    HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Setup

    HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\SQLServerAgent

    HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Tracking

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

???? ???? "??" ???? ??????? "? ??? ????? ???" ?????? ?????? "??? ???????? ??????? ? ???? ???????? ???????:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90


HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<MSSQL.x>
???????? ????? ??????? ?????? ???? <MSSQL.x> ?????? ?????? ?????? ???????? ?? ??????. ????? ????? ?????? ???????? ?? ?????? ?? ?????? ????? ??????? ???? ???? ?? ??? ?????? ?? ????? ??????? ?????? ??????. ??????? ????? ??????? ?? ??? ?????? MSSQLSERVER:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL\

?????? ???? ????? NTFS ??? ?????

????? "?????? ??????" ????? ??? ??????? ?? ???? MSSQLServer ????? SQLServerAgent (??? ???? Windows NT ???? ?? ???? ???? Windows NT) ??? ??? ???????? NTFS. ???????? ???? ????? ?????? ??????? ??? ?? ???? ?????????.

????? ??? ???? ????? ?????:
_instancename_\ D:\Program $ Server\MSSQL SQL Files\Microsoft
????? ??? ???? ?? ???? ???????:
Server\MSSQL\ SQL Files\Microsoft D:\Program
??? ?? ???? ???????? ??????? ???????? ????? ??? ????????.

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

?????? ??????? ?? ?? ???:
Drive: Server\<MSSQL.1>\MSSQL SQL \Program Files\Microsoft

???? ???????? ?? Windows

???? ???? ??????? ????????? ????? ??????? ???? ?????? Administrators ????? ???? ???? ???????? SQL Server ????? ????? ???? ????. ????? ???? ?????? Windows NT ????? ?? ?????? ?????? ???? ??? ??????? ??? ?????? Administrators ????? ? ?? ??? ?? ??? ??? ??????? SQL Server ???? ? ???? ???? ???????? ???? ????? ?? ???? ????. ??? ???? ?? ???? ?????? SQL Server ??? ??? ???? ???????? ?????.

?? SQL Server 2005 ??? ?? ??? ???? SQL Server ?? ???? ??? ??????? ???? ???? SQL ?? ???? ????? ?? ?????? Administrators ????? ???? ??? "???????? Windows NT ???? ? ?????????? ???????? ?? SQL Server ?????? ???????" ?? ??????? "????? ????? Windows ?????? ???????" ?? SQL Server 2005 ????????.

??? ?? SQL Server 2000 ??? ?? ??? ???? SQL Server ?? ???? ??? ??????? ???? ???? SQL ?? ???? ????? ?? ?????? Administrators ????? ?? ??? ????? ???? MSSQLServer ? ???? SQLServerAgent (??? ???? Windows NT ???? ?? ???? ???? Windows NT) ?? ???? ??? ?????? ???? ???????? ???:
  • ???? ???? ?? ???? ??????? = SeTcbPrivilege
  • ????? ?????? ????? = SeChangeNotify
  • ????? ??????? ?? ??????? = SeLockMemory
  • ?? ?????? ?????? ???? ???? ??????? = SeBatchLogonRight
  • ????? ?????? ????? = SeServiceLogonRight
  • ??????? ??? ????? ????? = SeAssignPrimaryTokenPrivilege
?????? ????? ??????? ????? ???? ?????? Microsoft Windows NT ???????? ??? ???? ????? ?????? ?? ????????.

?????? ????? ????? ??? ??????? ??? ??? ?? ??? ???? ???? SQL Server (MSSQLSERVER) ?? SE_MANAGE_VOLUME_NAME. ???? ??? ????? ?????? ?????? Windows ??? ????. ???? ????? ??????? ?? ??? ?? ??? ??? ?????????? ??????? ?? ???? ????? ?????????? ??? ??? ?????? "????? ???? ????? ???? ???????".

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

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

????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
239759
(http://support.microsoft.com/kb/239759/ )
?? ???? ??? ??? 5177 ??? ????? ????? ????????

??? ??? ???? ????? ???? MSSQLServer ????? ??? ???????? ??????? ? ??? ????? ???? ??? ??????? ?? MSSQLServer ? ????? SQLServerAgent ?? ?????? ??? SQL Server ????? ??????) ??? ?? ??? ???????? [Domain\NTaccount] ????? ???? ??? SQL Server.
  • ??? ??? ?? ???? ????????? ?????? Administrators ???????.
  • ?? ????? ????? ?????? BUILTIN\Administrators SQL Server.
??? ???? ??????: 
EXEC sp_grantlogin [Example\test]
? ?? ????? ??? ?????? ??? ??? ????? ??????: 
EXEC sp_addsrvrolemember @loginame = [Example\test] 
   , @rolename =  'sysadmin'

??? ??? ?????? SQL Server ?? ??? ??? ?? ???? ?? ?? ????? ?????????, ????? ?????? ??? ??????? SQL Server ???????? ?? ??? ??? ??? SEM ?? ???? ????????.

??? ????? ????? ?? ????? ?? ?? ???? ?? ????? ????????? ???? ??? "???????" ?? ??? ??????? ?????? ??? ???? ?? ?????????.

??? ??? ?????? ?????? Kerberos ?????? ??? ???? ????? (SSPI) ?? ???? SQL Server 2000 ? Microsoft Windows 2000 ? ???? ??? ?? ????? ????? ?? ?????? ??? ???? ????? (SPN) ?? ?? ?????? ????? ????? ???????? ??????? ???? ????. ???? ??????? "????? ???? ??????" ?? SQL Server 2000 ???????? ?????? ??? ???? ?? ????????? ??? ????? ??????? SETSPN ?????? ????.
???? ??? ?????? | ????? ???????

?????

????? ?? ?????????? ???? ??? ????? ???????? ??????? ?????? ?? "????? ??????? ?? Microsoft:
317746
(http://support.microsoft.com/kb/317746/ )
????? ?? ???? ?????? ?? SQL Server ????? ?????? ??????? ???????
317232
(http://support.microsoft.com/kb/317232/ )
???? ????? ?????? 1107 ? 1079 ??????? ??? ????? ???? ???? ???? ???? ??????
295051
(http://support.microsoft.com/kb/295051/ )
????? FIX: SQL Server ???? ??? ??????? ??? ?? ???? ???? ??????? ??????? ???????? ??? ???? ?????????
254321
(http://support.microsoft.com/kb/254321/ )
do's SQL Server ?????? ???????? don'ts ?????????? ????????
239885
(http://support.microsoft.com/kb/239885/ )
????? ????? ?????? ?????? ??? ???? ????? SQL
219264
(http://support.microsoft.com/kb/219264/ )
????? ????? SQL Server 7.0 ??????? ???????
198168
(http://support.microsoft.com/kb/198168/ )
BUG: ?????? ?? ???? ??? ????? ??????? ???? ???? ???????? SQL Server
????? ?? ?????????? ?? ?????? ???? Microsoft ?????? ??? ?????:
http://technet.microsoft.com/en-us/library/cc966496.aspx
(http://technet.microsoft.com/en-us/library/cc966496.aspx)
???? ??? ?????? | ????? ???????

???????

???? ???????: 283811 - ????? ??? ??????: 16/???/1430 - ??????: 11.2
????? ???
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 64-bit Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Workgroup Edition
????? ??????: 
kbmt kbinfo kbsql2005cluster kbhowtomaster KB283811 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????283811
(http://support.microsoft.com/kb/283811/en-us/ )
???? ??? ?????? | ????? ???????

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

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