????? ??????? ????? ?? SQL Server Desktop Edition ?? ?? SQL Server 2005 Express Edition

?????? ????????? ?????? ?????????
???? ???????: 319930 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ???? ????? ??? ????? ????? ????? ????? ?? Microsoft SQL Server Desktop Engine (MSDE) ?? ?? Microsoft SQL Server 2005 Express Edition.

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

?????? MSDE ???????? ?????:
  • ??? ?????? Windows (?????? Windows)
    ?? ??? ?????? Windows ? ???? ??????? ?????? ??? ???? ?????? Windows XP ?? Microsoft Windows 2000 ?? Microsoft Windows NT 4.0.
  • ??? ????? (?????? Windows ? ?????? ???? SQL)
    ?? "??? ??????" ???? ?????????? ??????? ?????? Windows ?? ?????? ???? SQL ??????? ????? MSDE. ???? ?????????? ????? ?????? ?? ???? ???? ?????? Windows XP ?? Windows 2000 ?? Windows NT 4.0 ??????? ????????? ??????? ??? ?? ??? ?????? Windows ?? ??? ??????.
??? ??? ???????? ????????? MSDE ?????? Windows. ????? MSDE ???????? ???? ?????? ????? (SA) ???? ?????. ??? ???? ????? ?????? ?????? ???? SQL ????????? ?? ????? ?????? ??? ???? ???? ??? ????? ??????.

????? ?? ????????? ??? ????? ???????? ?? MSDE ???? ???? MSDN ??????:
????? ????????
http://msdn2.microsoft.com/en-us/library/aa905171(SQL.80).aspx

???????

???? ??????? ??????? ??????? ?????? ??? ????? ?????? ???????? ?????? ? ??? ??????? ????????:
  • ????? Microsoft Windows XP Professional ?? Microsoft Windows 2000 Professional ???? ??????? Microsoft Windows 2000 Server ?? ???? ??????? Microsoft Windows 2000 Server ?? Microsoft Windows NT 4.0 Server
  • Microsoft MSDE 1.0 ?? ???? ??? ?????? Microsoft SQL Server 2000 (MSDE 2000)
????? ??? ??????? ??? ??????? ??? ???????? ???????:
  • ??????? ????? ????????
  • SQL ????????

??????? ?? MSDE ???????? ?????? Windows NT

???? MSDE ????? ???? ????? ?????? ?? Windows NT 4.0 ?? Windows 2000 ?? Windows XP ???????? ???? ?????? ???????? ???????? ?????? ?????? ?? ?????? ????? ??????. ???? ?????? ?????? ???????? ????? ??? ????? ?????? ??? ???? ??????? ?? ??? ?????? ?? ??? ?????? ???? ???? ???? Windows. ????? ????? ?????? ???? ???????? ?????? MSDE ??????? ????? ??? Windows ?????? ??? ?????? ?????? ?????? ?? ?????. ????? ??????? ???????? MSDE ??? ?????? Windows ? ?????? ??????? ??? ?? ????? ??? ????:
  • ??????? MSDE ?? ????????? ?????? (???????? ?????? Windows) ?? ????? ?????? ??? Windows ??? ???? ?????.
  • ??????? MSDE ?? ??? ??? ??? ????? ???? ?????? Windows ??? ?????? "???????" ?? ?????? ?????? ???? ?????? MSDE.
??????: ?? ????? "??? ??????" Windows ??? ????? ???? MSDE ??? ???? ??????? Microsoft Windows 98 ?? Microsoft Windows Millennium Edition (Me).

??????? ?? MSDE ???????? ?????? SQL

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

?? ??? ???????? ?? ??? ?????? ???????? ?????? ???? SQL. ???? ??????? ??????? ??? ??????? ??? ???? ??????? ?????? ???? SQL:
  • ??? ??????? MSDE ??? ???? ??????? Windows 98. ???? ?? ??? ?????? ??? ?????? Windows ?? ???? ??????? Windows 98 MSDE ?????? ?????? "????? ??????" ????? ??? ???? ??? Windows 98 (???? ???? ??? ?????? ???? SQL).
  • ??????? MSDE ??? ???? ????? ?? ?????? ?????? Windows. ?? ??? ??????? ???? ?? ???? ???? ?????? ???? ???? ?????? ?? ??? ???? Windows.
  • ?? ??? ???? Windows ?? ?? ???? ?? ???? ? ??????? ??? ?????? ???? ?????? ???? MSDE ???? ????? ???????. ??? ???? ???? ???? ????? ??????? ?????? ???? SQL ???????.
???? ????? ?????? ???? SQL ??? ??????? ????????? MSDE ??? ??? ???? ????? ????? MSDE ?????? ?????? ???? SQL (??? ??????) ?? ??? ????? "??? ??????" ?????? ??? ?????? ???????. ???? Microsoft ????? ?????? "????? ??????" ????? ????? ??????? ??? ????? ????? ???????? ??? ??????? ????? "Windows Registry" ??????.

?????: ?? ????? ???? ???????? SA ?????? ???? ???? ????. ?????? ??? ?? ??????? MSDE ?????. ??? ???? ??? ?? ????? ?????? ???? SQL ??? ????? ???? ???? ???? ?????? ?????. ?????? ???? ???? ???? SA ??????? ???? ??????? ??????? ???????? OSQL, ????? ?? ???? ?????? ???? ????? ??????? ?? MSDE:
  1. ??? ????????? ???? ?????? ???? MSDE ???? ???? ???? ???? ???????.
  2. ???? ????? ?????? ?? ???? ????? ??????? ENTER:
    osql U sa
    ??? ??????? ??????? ????????? ???? MSDE ???????? ???? SA.
  3. ???? ??????? ??????? ?? ???? ?????? ?? ???? ????? ??????? ENTER:

    ??????: ???? ?? ??????? 'mynewpassword' ???????? ???? ?????? ???????.
    sp_password ????? ?? 'mynewpassword' ?? 'sa'

    go
    ???? ???? ??????? ??????? ???? ???? ??? ????? ???? ?????? ?????? ?? ?????:
    Password changed.
    						
????? ?? ????????? ??? ????? ??????? ?????? ???????? OSQL ???? ???? MSDN ??????:
?????? ???????? osql
http://msdn2.microsoft.com/en-us/library/aa214012(SQL.80).aspx

????? ?????? "????? ??????" ????? ???????

????? ???????? ???? ????? ??? ?????? ?????? MSDE ?? ???? ????? ??????? ?? ????? ????? ??????:
SECURITYMODE=SQL
				
????? ??? ????? ???? MSDE ?????? ?? ?????? "????? ??????". ?? ??? ???????? ??? ????? ??????? MSDE ???????? ?????? Windows ?? ?????? ???? SQL.

????? ?????? "????? ??????" ??? ???????

??? ??? ?????? ?? ????? ?? ?????? ??? ????? ?????? ?? ????? ????? ???????. ??? ???? ?? ???? ?????? ????? ?? ???? ????? ????? ?????? ??? ?????. ????? ???? ?? ???? ??????? ??????? ??????. ?????? ??? ??????? ??????? ??? ???? ???????? ?? ????? ??? ??????. ?? ????? ??????? ????? ?? ???? ???? ?????. ?????? ??? ???? ?? ????????? ??? ????? ??? ???? ???????? ?? ????? ????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
322756????? ??? ???? ???????? ? ??????? ??????? ?? Windows
?????????? ??? ????? ???? ??????? ?????? ??????? Windows LoginMode 1 ?? ?????? Windows. ?????? ?????? "????? ??????" ??? ??????? ??? ????? ??? ?????? ??? 2.

????? ?????? ?????? LoginMode ??? ?? ??? ??? ?????? MSDE ????? MSDE ????????? ?? ????? ?????. ??? ??? ?????? MSDE ????? ????????? ???? ??????? ?????? LoginMode ?? ????? ??????? ?????? ??????:
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
??? ??? ?????? MSDE ????? ????? ???? ??????? ?????? LoginMode ?? ????? ??????? ?????? ??????:
HKLM\Software\Microsoft\Microsoft SQL Server\<Instance Name>\MSSQLServer\LoginMode
??? ??? ?????? SQL Server 2005 Express Edition, ???? ????? ??????? LoginMode ?? ????? ??????? ?????? ??????:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer
?????? ?????? LoginMode 2 ? ???? ??????? ???????:
  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\


    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer
  4. ?? ????? ??????? ???? ????? ??????? ??? ??????? ?????? LoginMode.
  5. ?? ???? ?????? ???? DWORD ????? ???? ??? ??????? ?????? ??? 2 ???? ?? ????? ?????? Hex ?? ???? ??? ?????.
  6. ????? ????? ?? MSSQLSERVER ???????? SQLSERVERAgent ??? ??????? ???? ???????.

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

???? ??????? ??????? (???? ???? ????? ??? ?????) ?????? ?? ??? ????? ??????? ???? ???? ???? MSDE:
  1. ???? ??? ?????? ?????? ??? ??? ???? ????????? ? ???? ??? ???? ?? ???? ??? ????? ??. ????? ????? ????? Test.udl.
  2. ???? ????? ??????? ??? ????? & .udl ???? ???? ?????? ????? Data Link.
  3. ?? ????? ??????? "????" ? ???? ??? ???? Microsoft OLE DB ?? SQL Server.
  4. ?? ????? ??????? "?????" ? ???? ??????? ???????:
    1. ??? ?????? 1 ? ??? ?? ???? ?????? ???? ???? ??????? ??.
    2. ??? ???? 2 ? ??? ??? ???????? ???????:
      • ??????? Windows NT ???????? ??????
        ??? ??? ?????? ??? ??? ?????? ?????? Windows.
      • ??????? ??? ?????? ???? ????? ????
        ??? ??? ?????? ??? ??? ?????? ?????? ???? SQL. ??? ???? ??? ??????? ??? ???? ????? ??? ???????? ????? ??????.
    3. ???? ??? ?????? ???????. ?? ???? ???? ??????? ???? ????? ???? ??? ?????? ???????.

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

  • ??? ?? ??? ????? ???? SQL Server ??????, ???? ??????? ????????. ???? ?? ????? ???? SQL Server ?? ???? ??? ??? MSSQLServer ?? ????? ??????? ?? ???? ?? ??? ?????? ?? "?????".
  • ??? ?????? ??????? MSDE ???????? ???? SA ??????? ?? ???? ??????? ??? ??? ??? ?? ??? ?????? ?????? ???? ???? ??????.
  • ??? ??? ?? ????? ????? ?????? ???????? OSQL ??? ????????? ???? ?????? MSDE ? ????? ?????? ???????? OSQL ?? ??????? ??? ?? ?? ???????? ??? ????? ??? ??????? - U ?????? ?????? ?? ????? ???????. ??? ???? ??????:
    osql -s servername - U sa

?????

????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
325022?????? ??????? MSDE
?????? ??? ???? ?? ????????? ??? ??????? ???? Windows ??? ?? ????? ?????? ??????? ?? SQL Server 2000 Desktop Engine ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
227091???? ????? ??? ??????? ?????? Microsoft Windows Installer
?????? ??? ???? ?? ????????? ??? ????? ??? ???????? ????????? ?? SQL Server 2000 Desktop Engine ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
285097????? ????? ??? ?????? ????? ?????? ????????? ??? SQL ????? ????? SQL Server 2000 Desktop Engine ???????? Windows Installer
????? ?? ????????? ??? ??????? SQL Server Desktop Engine ???? ????? Microsoft ???????? ??? ?????:
SQL Server 2000 ??? ?????? Engine (MSDE 2000)
http://msdn2.microsoft.com/en-us/sql/aa336301.aspx

????? MSDE 2000 ?? ????????? ?????? ??
http://www.microsoft.com/sql/prodinfo/previousversions/msde/msdeintegration.mspx

???????

???? ???????: 319930 - ????? ??? ??????: 01/????? ??????/1428 - ??????: 4.5
????? ???
  • Microsoft SQL Server 7.0 Desktop Edition
  • Microsoft SQL Server 2000 Desktop Engine (Windows)
  • Microsoft SQL Server 2000 64-bit Edition
  • Microsoft SQL Server 2005 Express Edition
????? ??????: 
kbmt kbhowtomaster KB319930 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????319930

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

 

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