????? ?????? ?? ????? ???? ???? ????? ?????? ?? MSDE ?? SQL Server 2005 Express Edition

?????? ??? ??????? ???? ????? ??????? ????? ??????? ?????? ???? ???? ???? SQL sa (????? ??????).

????? ????? Microsoft SQL Server 2005 Express ??????? Microsoft SQL Server Desktop Engine (MSDE) 2000 ?? ????????? ??????? ?? Microsoft SQL Server ???? ?????? ?? ??? "?????? ??????". ??? ????? ???? sa ????? ????? ??????? ????? ???? sa ???? ?????? ?? ???? SQL Server. ???? ?????? sa ???? ??????? ????? (NULL) ? ??? ??? ??? ?????? ???? ?????? ??? ????? ?????? ??????? MSDE. ?????? ?? ???? ??????? ?????? "? ??? ????? ???? ?????? sa ??? ???? ???? ???? ?? ???? ?????.

????? ?????? ?? ???? ???? ???? SA ????

1. ??? ????????? ???? ?????? ???? MSDE ???? ???? ???? ???? ???? ???????.
2. ?? ???? ???????? ???? ????? ?????? ?? ?? ???? ????? ??????? ENTER:
   
   osql U sa
   
   ??? ??????? ??????? ????????? ???? MSDE ???????? ???? sa. ??????? ??? ???? ???? ????? ??? ??? ?????????:
   
   osql - U sa -S servername\instancename
   
   ??? ???? ?? ???????? ???????:
   
   ???? ??????:
3. ???? ENTER ??? ????. ????? ??? ????? ???? ???? (?????) NULL ?? "sa.
   
   ??? ??? ???? ?? ???? ?????? ??? ??? ENTER, ?? ?? ??? ???? ???? ???? ????? sa:
   
   1>
   
   ?? ???????? ????? ???? ???? ???? ? ??? NULL ?????? ?? ??????? ??????.
   
   ??? ???? ?? ???? ???? ????? ????? ??????? ??? ??? ?????? ???? ???? ??? ?????. ???? ????? ????? ??? ??? ????? ???? ???? ???? sa:
   "????? ?????? ??? ???????? 'sa'."
   ???? ????? ????? ??????? ??? ?? ????????? ???? ????? ??????? SQL Server ?? ?????? ??? ?????? Windows ???:
   ??? ????? ?????? ???????? 'sa'. ?????: ??????? ??? ????? SQL Server ????? ??.
   ?? ???? ?????? ?? ???? ?????? sa ????? ??? ?????? Windows. ??? ???? ????? ????? ???? ???? sa ???? sa ????? ?? ???? ??? ???????? ????? "??? ??????" ?? ????????.
   
   ?? ???? ???? ????? ????? ??????? SQL Server ?? ?? ???? ??? ??????? ?? ????? ??? ??? ???? ?? ??? ???? SQL Server ???? ???????:
   ??????? ????????SQL Server ??? ????? ?? ?? ??? ??????.
   ??????? ????????ConnectionOpen (Connect()).

????? ????? ???? ?????? SA

1. ??? ????????? ???? ?????? ???? MSDE ???? ???? ???? ???? ???? ???????.
2. ???? ????? ?????? ?? ???? ????? ??????? ENTER:
   
   osql U sa
   
   ?? ???? ??????: ?????? ?? ???? ????? ??????? ENTER ??? ???? ???? ?????? ????? ?? ???? ???? ?????? ???????. ??? ??????? ??????? ????????? ???? MSDE ???????? ???? sa. ??????? ???????? ?????? Windows ???? ??? ?????: ??????? osql E
   
   ?????? ??? ??? ?????? SQL Server 2005 Express, ???? ??????? ?????? ???????? Osql ???????? ?????? ????????? ???? ?????? ???? Osql ??????. ?????? ?????? ???????? Sqlcmd ????? ?? ???.
   
   ????? ?? ????????? ??? ?????? ???????? Sqlcmd ?? ?????? ???? ???? ????? Microsoft (MSDN) ?????? ??? ?????:
   http://msdn2.microsoft.com/en-us/library/ms165702.aspx
   (http://msdn2.microsoft.com/en-us/library/ms165702.aspx)
3. ???? ??????? ??????? ?? ???? ?????? ?? ???? ????? ??????? ENTER:
   

   sp_password @old = null, @new = 'complexpwd',  @loginame ='sa' 
      go

   ?????? ???? ?? ??????? "complexpwd" ?? ???? ?????? ?????? ???????. ????? ???? ???? ???? ?????? ??????? ???? ? ???? ? ?????? ?????? ??????? ????? ?????.
   
   ?????? ??????? ????? ???????? ???? ???? ??? ????? ???? ?????? ?????? ?? ?????:
   ????? ???? ??????.

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

??? ??? ?????? ?? ????? ?? ?????? ??? ????? ?????? ?? ????? ????? ???????. ??? ???? ?? ???? ?????? ????? ?? ???? ????? ????? ?????? ??? ?????. ????? ???? ?? ???? ??????? ??????? ??????. ?????? ??? ??????? ??????? ??? ???? ???????? ?? ????? ??? ??????. ?? ????? ??????? ????? ?? ???? ???? ?????. ?????? ??? ???? ?? ????????? ??? ????? ??? ???? ???????? ?? ????? ????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:

??? ?? ??? ??????? ?? ????? ?????? ?? ??? ?????? ????? MSDE ???? ????? ????? ??????? ????????. ?????????? ??? ????? ???? ????? ??????? ?????? Windows LoginMode 1 ?? ?????? Windows. ??? ????? ?????? ????? ?????? ? ??? ?????? ?? 2.

• ????? ?????? ?????? LoginMode ??? ?? ??? ??? ?????? MSDE ???????? MSDE ???? ?? ????? ?????. ??? ??? ?????? MSDE ????? ????????? ???? ??????? ?????? LoginMode ?? ????? ??????? ?????? ??????:
  HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
  
  ?????? ??? ??? ?????? SQL Server 2005? ?? ????? ???? ??????? ?? ???? ???? ? ??? ???? ????? ??????? ?????? ??????. MSSQL.x ?????? ?????? ?????? ???????? ?????? ????? ??:

  HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.x\MSSQLServer
• ??? ??? ?????? MSDE ????? ????? ???? ??????? ?????? LoginMode ?? ????? ??????? ?????? ??????:
  HKLM\Software\Microsoft\Microsoft SQL Server\%InstanceName%\MSSQLServer\LoginMode

?????? ??? ??????? ??? ????? ???????? ??? ???? ????? ???? ???? sa ????? ????? ???? ???? ??????.

??????? ?? "??? ??????" ??? ?????? (Windows) ????????, ???? ??????? ???????:

1. ?????? MSSQLSERVER ? ???? ??????? ?????? ??? ????? (??? SQLSERVERAgent) ??? ?????? "???????" ?? "???? ??????".
2. ???? ???? ???????. ??? ???? ??????? ???? ??? ???? ?? ???? ??? ????? ?? ?? ????: "regedt32" (???? ?????? ????????)
   
   ???? ??? ?????.
3. ??? ???? ??? ????????? ???????? ???????? (???????? ??? ?? ??? ??? ?????? MSDE ????? MSDE ????????? ?? ????? ?????:
   HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\MSSqlServer
   ??
   HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\<Instance Name>\MSSQLServer\
4. ?? ????? ??????? ???? ????? ??????? ??? ??????? ?????? LoginMode.
5. ?? ???? ?????? ???? DWORD ????? ???? ??? ??????? ?????? ??? 1. ???? ?? ????? ?????? Hex ?? ???? ??? ?????.
6. ????? ????? ?? MSSQLSERVER ???????? SQLSERVERAgent ??? ??????? ???? ???????.

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

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

• ????? ???? ????? ?????? ????? ?? sa "???????? ???? ???? ??? ?????. ???? ???????? ???? ??? ??? ??? ???? ???? ????? ????? ?????? sa. ????? ?????? ?? ?? ???? sa ??????? ?? ???? ???? ???? ??? ????? ?????? ???????? ?? ??????? "????? ?????? ??????? (SA) ??????" ?? SQL Server ???????? ? ??? ?? ???? ??? ?????? ??????? ???? sa.
• ??? ???? 1433 ?? ??????? ?????? ?? ?? ?????? SQL Server ??????? ??? ???? ????.
• ??? ??? ??? ?? ???? ?????? 1433 ?????? ??? ??????? ??????, ????? egress ingress ??????? ???? ????? ??????? ??????.
• ????? ???? SQLServer ? SQL Server ???? ??? ???? Microsoft Windows NT ??? ???? "?????? ??????".
• ????? ?????? Windows NT Microsoft ?? ?? ?????? ????? ??????? ?????? ??????? ???? ???????. ?? ?? ?????? ?? ????? ????? ???? MSSQLServer. ????? ??????? ???????? Windows NT ????????.

????? ?? ????????? ??? ????? ??????? ???? ???? sa ?????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft: ?????? ??? ???? ?? ????????? ??? ????? ?? ?????? ?? ????? ????? SQL Server 2000 Service Pack 1 ??? ????? ??? ?????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft: