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

???? ID: 319930 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
???? ?????? ???????????? ?????? ???????? KB ?? ???????? ????? ?? ??? ???? ????? ????
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

??????

?? ??? ?? ??? ???? ????? ???? ?? ?? ?? Microsoft SQL Server ???????? ????? (MSDE) ?? Microsoft SQL Server 2005 ????????? ??????? ?? ?? ?????? ?? ??? ??? ??????? ??????? ???? ?? ??? ???? ?????

???:?? ?? ????????? ?? ?? ???? ??? ????? MSDE ?? ???? ??? ?? ???? SQL Server 2005 ????????? ??????? ?? ????

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

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

??????????

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

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

MSDE ????? ?? ????? ?? ????????? ???? ?? ??? ???? ??????? ?????????? ?? ??????? ????????? ?? ????? ?? Windows NT 4.0, Windows 2000 ?? Windows XP ?? ??? ????? ??????? integration achieves ??? ???? ?????????? ??????? ??????? ????????? ??????? ????? ?? ??????? ?? ?? Windows ????? ???????? ?? ????? ??? ?? ?????????? ??????? ?? ?????? ???? ?? ?????? ???? ??, MSDE ???????? ??????? ?????????? ??? ????????? ???? ?? ??? Windows-?????? facilities ????? ???? ??? ??????????? ?????? ???? ?? Windows ?????????? ?? ??????? MSDE ??????????, ?? ??? ????? ??? ?? ?? ?????? ?? ????:
  • ??????? ???????? ?? (?????? Windows ????? ?? ????? ????), ?? Windows ?? ??? ?? ???? ?????????? ???? ?? ??????? ?? ?????? MSDE ???? ?? ??? ???
  • ?????? MSDE ?? ?????? ??? ?? ??? MSDE ????? ???? ???? ?????? ?????? ?? ?????????? ???? ?? ??? Windows ?????????? ???? ??? ????? ??? ???
???:: ?? ?? Microsoft Windows 98 ?? Microsoft Windows Millennium Edition (Me) MSDE ?? ?? ???????? ?? ??? ?? Windows ?????????? ??? ?????? ???? ???

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

?? ??? ?????????? ????????? ????? ??? ?? ??????? ?? ???-????????? ??????? ?? ?????? ???? ??, MSDE ??? ???? SQL ????? ????? ???? ??? ???? ??? ?? ?? ?????????? ?? ????????? ???? ?? ?? ??????? ?? ??? ???? ??????? ?? ???? ?? ??????? ????????? ???? ??? ??? MSDE ?? ??? ?? ????? ???? ??? ???? ??, ?? ?????????? ???? ???? ???

??? ???????????? ?? ??? ???? ?? ???? ?? ???? ?????? SQL ????? ??????? ?? ????? ???? ?? ???? ????? ???? ??? ??? ???????????? ??? ?? ?? SQL ????? ??????? ?? ????? ???? ?????? ??? outlines:
  • MSDE Windows 98 ?? ?? ??? ??? Windows ?????????? ??? Windows 98 ?? ??????? ???? ??, ??????? MSDE ????? ??????? ??? ?????????? ?? ?? Windows 98 ?? ?? ??? ?? (????? ???? SQL ????? ??????? ?? ?????? ???? ??)?
  • ???? ?????? ???? ?? ??? MSDE Windows ????? ?? ????? ???? ?? ?? ???? ??????? ?? ??? ?? ?????? ???, ?? ??? ????? ???????? ?? ?? ???? Windows ???? ????? ?? ???? ????
  • ???? Windows ???? ???? ??, ?? ???? ???? ?? ????, ?? ?? ?? ?????? ???? ?? ?????? ?? ??? ??? ?? MSDE ?? ?????? ????? ???? ???? ?????? ??? ????? ??? ???????, ?? ?? ????? ?? ???? ??? SQL ????? ??????? ?? ??? ?????? ???? ?? ??? ???? ???
SQL ????? ??????? MSDE ?? ??????? ??????? ?? ??? ????? ???? ??? ??, ??????? ?? ?? MSDE ??????? SQL ????? ??????? (??????? ???) ?? ????? ???? ?? ??? ???????? ???? ????, ?? ?? ???????? ??? ?? ????? ???? ?????? ??????? ??? ?? ??????? ????? ?? ???? ??? Microsoft ??????? ???? ?? ?? ?? ????? ??????? ?? ????? ??????? ??? ?????????? ??????? post-installation ????????? ?? ???????? ?? ?? ?? ???????? ??? ?? ??????? ????Windows ?????????
(http://msdn2.microsoft.com/en-us/library/ms970651.aspx)
.

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

    ???:: ????? ????????? ???? ?? ?? ?????'mynewpassword'??? ??? ????????
    ??, sp_password'mynewpassword', 'sa'

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

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

??????? ?? ????? ????? ??????? ???????? ?? ??? ??????? ????? MSDE ?? ????? ???? ???? ?????????? ??? ????????? ?? ???? ???:
SECURITYMODE=SQL
?? ???? ???????? MSDE ??????? ??? ?????????? ?? ??? ??????? ???? ?? ???? ???? ??? With this authentication mode, you can connect to MSDE by using Windows Authentication or SQL Server Authentication.

Enable Mixed Mode authentication after installation

???????????? ???, ????, ?? ????? ?? ????????? ?? ??????? ???? ?? ??? ????? ????? ??? ???? ???????, ??? ?? ????????? ?? ??? ??? ?? ??????? ???? ??? ?? ????? ???????? ??????? ?? ???? ???.. ?????, ????????? ???? ?? ?? ?? ????? ?? ??????????? ???? ???? ???.. ?????? ??????? ?? ???, ????????? ?? ??????? ???? ?? ???? ???? ??? ?? ???.. ???, ??? ??? ?????? ??????? ???? ?? ?? ?? ????????? ?? ???????????? ?? ???? ???.. ????????? ?? ??? ?? ???? ?? ???????????? ???? ?? ????? ?? ???? ??? ???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
322756
(http://support.microsoft.com/kb/322756/ )
??? ?? ???? ?? Windows ??? ????????? ?? ???????????? ???? ????
By default, the value of theLoginModeWindows registry subkey is set to 1 for Windows Authentication. To enable Mixed Mode authentication after installation, you must change this value to 2.

The location of theLoginModesubkey depends on whether you installed MSDE as the default MSDE instance or as a named instance. If you installed MSDE as the default instance, theLoginModesubkey is located in the following registry subkey:
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
If you installed MSDE as a named instance, theLoginModesubkey is located in the following registry subkey:
HKLM\Software\Microsoft\Microsoft SQL Server\<instance name="">\MSSQLServer\LoginMode</instance>
If you are using SQL Server 2005 Express Edition, theLoginModeregistry entry is located in the following registry subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer
To change the value ofLoginModeto 2, follow these steps:
  1. In Control Panel, open the Services tool to stop MSSQLSERVER and all other related services (such as SQLSERVERAgent)
  2. To open Registry Editor, click???????????? ????,???????????:Regedt32?? ????-????? ????, ?? ???? ???OK.
  3. Locate one of the following subkeys (depending on whether you installed MSDE as the default MSDE instance or as a named instance):
    HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\MSSqlServer\


    HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\ <instance name="">\MSSQLServer\</instance>


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

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

????????? ???? ?? ?? ?????? ?? ???? ??? ?? MSDE ?? ?? ?????? ?? ??? (?? ?? ????? ?? ??? ??????? ???? ???) ????? ????? ?? ???? ????:
  1. ???? ???????? ?? ???????? ?? ????-????? ????, ????? ????????? ????-????? ????, ?? ???? ?????? ????????. ????? ?? ??? ?????Test.udl.
  2. .Udl ????? ?? ????? ?? ??? ???-????? ???????? ???? ???????? ????? ?? ??????? ?? ??? ?? ..
  3. ????? ????Provider??? ??,SQL ????? ?? ??? Microsoft OLE DB ???????.
  4. ????? ?????????????? ??, ????? ????? ?? ???? ????:
    1. ???? 1, ?? ??????? ?? ??? ???? ?? ????? ?? ?????? ???? ????? ??? ???? ?????
    2. ???? 2, ?? ??????? ????? ???????? ??? ?? ?? ?????:
      • Windows NT ?????? ??????? ?? ????? ????
        ??? ?? Windows ?????????? ?? ????? ?? ??? ???, ?? ?? ?????? ?? ??? ?????
      • ????????? ?????????? ??? ?? ??????? ?? ????? ????
        ??? ?? SQL ????? ??????? ?? ????? ?? ??? ???, ?? ?? ?????? ?? ??? ????? ??? ?? ?? ?????? ?? ??? ????, ???? ?????? ?????????? ??? ?? ??????? ??????
    3. ????? ????,??????? ???????. ??? ??????? ??? ???? ??, ?? ?? ?? ??????? ??????? ??? confirms ?? ????? ??????? ???? ???

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

  • SQL ????? ???? ??????? ??? ?? ???? ??? ??, ??? ???? ??????? ?? ???? ???? ?? ???? ??? ???????? ???? ?? SQL ????? ???? ?? ??? ??, ?? ??? ????? ????MSSQLServer????? ??????? ??? ????? ?? ???? ??? ?? ????????? ???? ?? ?????? "????." ?? ??? ??? ????????? ???? ???? ??
  • ?? ?? MSDE ???? ?? ??? ?????????? SA ???? ?? ????? ?? ?????? ???? ?? ?????? ????, ???? ??????? ??? ???? ???? ?? ?? ?? ???? ?? ??? ?? ??????? ??? ??, ?? ???? ?? ???? ???
  • ??? ?? OSQL ?????? MSDE ????? ???? ???? ???????? ?? ???? ????? ?? ????, OSQL ?????? ?? ???? ???? ???????? ?? ?????, ?? ???? ??? ?? ????? ????-U??????? ???? ??? ????? ?? ????????? ???? ?? ??? ???????-?????? ?????? ?????? ?? ???::
    osql -sServername-U sa
????? ?? ???? ???? | ??????????? ???

??????

???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
325022
(http://support.microsoft.com/kb/325022/ )
MSDE ??????? ?? ???????
??? SQL Server 2000 ???????? ????? ?? ??? ????? ??????? ???, ?? Windows ???????? ?? ????? ???? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
227091
(http://support.microsoft.com/kb/227091/ )
Microsoft Windows Installer ????? ?? ??? ???????-?????? ???????
For more information about changing the default authentication mode for SQL Server 2000 Desktop Engine, click the following article number to view the article in the Microsoft Knowledge Base:
285097
(http://support.microsoft.com/kb/285097/ )
How to change the default login authentication mode to SQL while installing SQL Server 2000 Desktop Engine by using Windows Installer
For more information about using SQL Server Desktop Engine, see the following Microsoft Web sites:
SQL Server 2000 Desktop Engine (MSDE 2000)
http://msdn2.microsoft.com/en-us/sql/aa336301.aspx
(http://msdn2.microsoft.com/en-us/sql/aa336301.aspx)


Integrating MSDE 2000 with your Applications
http://www.microsoft.com/sql/prodinfo/previousversions/msde/msdeintegration.mspx
(http://www.microsoft.com/sql/prodinfo/previousversions/msde/msdeintegration.mspx)
????? ?? ???? ???? | ??????????? ???

???

???? ID: 319930 - ????? ???????: 03 ?????? 2010 - ??????: 2.0
???? ???? ???? ??:
  • Microsoft SQL Server 2000 64-bit Edition
  • Microsoft SQL Server 2005 Express Edition
??????: 
kbhowtomaster kbmt KB319930 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:319930
(http://support.microsoft.com/kb/319930/en-us/ )
????? ?? ???? ???? | ??????????? ???

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

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