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

?????? ????????? ?????? ?????????
???? ???????: 322336 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

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

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

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

  1. ??? ????????? ???? ?????? ???? ???? MSDE ???????? ???? ???? ???? ???????.
  2. ?? ???? ???????? ???? ????? ??????? ??????? ???? ????? ??????? ENTER:

    osql-U sa

    ?????????? ??????? ????????? ?????? ? MSDE ???????? ???? sa . ??????? ????? ???? ????? ??? ??? ???????????:

    servername\instancename-S sa-U osql

    ??? ???? ?? ??????????????:

    ???? ??????:
  3. ???? ENTER ??? ????. ??? ??? ??? ????????? ????? NULL (?????) sa.

    ??? ??? ???? ???? ???????? ??? ?????? ENTER? ?? ??? ???? ???? ???? ????? sa :

    1 >

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

    ??? ???? ?? ???? ???? ????? ??? ???????? ??? ????? ???? ???? ??? ?????. ?? ????? ??? ????????????? ????? ??? ???? ???? ????? sa :
    "??? ????? ?????? ????????' sa '."
    ???? ????? ????? ??????? ??? ?? ??? ????????? SQL Server ?? ????? ????????? ??? ?????? Windows ???:
    ??? ????? ?????? ???????? 'sa'. ?????: ??? ????? ?????????? ????? ??????.
    ?? ????? ?????? ?? ???? ?????? sa ?? ??? ?????? Windows. ??? ???? ????? cancreate ???? ???? sa ??? ??? ??? ???? sa ??? ?? ??? ??? ???????? ?????? ?? ???????? ????? ?? ????????.

    ??? ????? ????? ????? ???????? ?? ?? ???? SQL Server ?? ???? ???? ?? ?????? ??? ??? ???? ????? ???? ?? SQL Server ???????:
    [??????? ????????]???? SQL ??? ????? ?? ?? ??? ??????.
    [???????????]????????????? (Connect()).

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

  1. ??? ????????? ???? ?????? ???? ???? MSDE ???????? ???? ???? ???? ???????.
  2. ???? ????? ??????? ?? ?????????:

    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
  3. ???? ??????? ???????? ??? ???? ?????? ???????? ENTER:
    sp_password @old = null, @new = 'complexpwd',  @loginame ='sa' 
       go
    ??????: ???? ?? ??????? "???????????" ?? ???????????? ???????. ???? ???? ???? ????? ???? ?????? ????? ????? ??????? ???? ?? ??????? ???? ????.

    ??? ???????? ??? ????? ???????? ???? ???? ??? ?? ???????? ???? ?????? ?????? ?? ?????:
    ????? ???? ??????.

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


??? ????? ??? ?????? ?? ??????? ?? ?????? ??? ??????? ???? ???? ????? ????? ???????. ??? ???? ?? ???? ?????? ????? ??? ??? ?????? ??????? ???? ??? ????. ????? ???? ?? ????? ??????? ??????? ??????. ??????? ????????? ?? ?????? ???? ???????? ????? ??? ??????. ??? ???? ????? ??????? ????? ?? ???? ???? ?????. ????? ?? ????????? ??? ????? ??? ???? ???????? ?? ????? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ????? Microsoft":
322756 ????? ??? ???? ???????? ?? ????? ????????? ?? Windows


??? ?? ??? ??????? ?? ????? ?????? ?? ??? ?????? ????? MSDE? ????? ?????? ?? ????? ????? ???????. ???? ???????? ??? ????? ???? ????? ??????? ?????? Windows LoginMode 1 ??????? Windows. ??? ????? ?????? "??? ?????"? ??? ?????? ?? 2.
  • ????? ?????? ?????? LoginMode ??? ?? ??? ??? ?????? 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? ???? ?????? " ??????? " ?? "???? ??????".
  2. ???? "???? ???????". ???? ???? ???????? ???? ??? ????? ?? ???? ??? ?????? ?????: "regedt32" (???? quotationmarks)

    ???? ??? ?????.
  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. ???? ?? ????? ???????? ???? ? ??? ?? ???? ??? ?????.
  6. ?? mssqlserver. @ ??? ????? ?????? forthis ????? SQLSERVERAgent ???? ???????.

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

?? ???? ?? ??????? ???? ???? ???? ??? ?????? ???? ??????? ???? ?? ?????? ??????? "???? ?????????" ??? ????? SQL Server.
  • ????? ???? sa ????? ?????? ???????? ???? ???? ?????. ???? ??????? ????????? ??? ??? ??? ???? ???? ????? ????? ?????? sa . ????????? ?????? ?? ?? ???? sa ??????? ?? ???? ???? ????? ??? ????? ?? ?????????????????????? ?? ????? "?????? ??????? (SA) ??????" ?? SQL Server ??????????? ??? ?? ???? ??? ?????? ??????? ???? sa .
  • ??? ???? 1433 ?? ?????? ??????? ??? ???????? Server ??????? ??? ???? ????.
  • ??? ??? ??? ?? ???? ?????? 1433 ?????? ??? ?????? ?????? ????? ??? ???? ?????? ??????? ??????? ???? ????? ??????? ??????.
  • ????? SQLServer ???? ????? SQL Server ??? ???? Windows NT? ???? "?????? ??????" ??? ??????????.
  • ????? ?????? Windows NT Microsoft? ?? ????????????? ??????? ????? ?????? ??????? ????????. ?? ????? ?????? ????? ???? ????????????. ????? ??????? ???????? Windows ?????????????.

?????

????? ?? ????????? ??? ??? ??? ??????? ???? ???? sa ?????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
313418 PRB: ???? SQL Server ??? ?????? ???????? ???? ???? ????? (NULL) SA ?????? ??????? ???????
????? ?? ????????? ??? ????? ?? ???? ?? ??? SQL Server 2000 Service Pack 1 ????? ????? ??? ????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
274773 ?????: ??? ??? ?????? ???? Windows ??? "????" Windows/SQL? ???? ???? SA ??????

???????

???? ???????: 322336 - ????? ??? ??????: 24/????/1435 - ??????: 7.0
????? ???
  • Microsoft SQL Server 2000 64-bit Edition
  • Microsoft SQL Server 2005 Express Edition
????? ??????: 
kbsqlsetup kbhowtomaster kbmt KB322336 KbMtar
????? ????
???: ??? ????? ??? ??????? ???????? ????? ?????????? ??????? ?????? ??? ??????? ?? ??? ??????? ?? ??????? ??? ??? ?? ???? ????????? ???? ??????? ???????(CTF) ?? ?? ???? ????? ????. ???? ?? ???? ?????????? ??? ???????? ???????? ???? ??? ?? ???????? ??????? ?? ??? ??????? ???????? ?? ??? ??????? ??????? ??? ?????? ?? ?????? ??? ???? ???????? ???????? ?? ????? ??????? ????? ????? ??????. ??? ?? ???????? ???????? ?? ????? ??? ????? ?? ???????? ?? ???? ????? ?? ?????. ?????? ??? ???? ?????????? ???? ?????? ?? ??? ????? ?? ??? ??? ?? ??????? ?? ??? ????? ?? ???? ????? ????? ?? ????? ??????? ???? ?? ???????? ?? ??? ???????.
???? ??? ????? ??????? ?????? ??????????322336

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

 

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