????? ????? ????? SSL ?? SQL Server 2000 ??? ??? ???? "???? ????????" ?????

?????? ????????? ?????? ?????????
???? ???????: 276553 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ???? ????? ??? ??????? ???? ??? ???? ??????? ?????? ????? ???? ???? ??????? ?????? (SSL) ?? ??? Microsoft SQL Server 2000 ??? ??? ???? "???? ????????" ????? ?? ???? ???? ???????. ??? ??? ????? ???????? ?? ???? ??? ?????? ????? "? ???? ????????? ???????? ?? ??? ??????. ???? SQL Server 2000 ????????? ??????? ??? ???? ?????? ???? ??????? ???????? ?????? ????? SSL. ????? ????? ????? SQL Server ???????? SuperSocket Net-????? Ssnetlib.dll ?? Dbnetlib.dll

?? ???? ??????? ????? SSL ??? ???? ???? SQL ????? ??????? ??? ????????? ???? ??? ??? ??? ?? ??? ????? ??????? ??? ??? ???? ???? ???? ???? ?? SQL Server ??????? "?" ??? ????????? ???????. ???????? ??? ???? ???? Microsoft ??????? ??????? ???????? ? ??? ????? SSL ??? ???? ???? SQL:
  1. ?? ?????? ???????? ??? ?? ???? ?? ??????.
  2. ????? "?????? ????? ??????? ??" ??? ?? ????.
  3. ????? ?????? ????? ???????? ??? ?? ????? ????????? ??????? ???????? "???? ??????" ????????.
????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
319349BUG: ????? ?????? "??? ???????? ?????" ????? ????????? ??? ??? ???? ??? ?????
?????? ??????? ??? ???? ??????? ???? ????? ??? ????? ????? ??? ??? ???? ??????? ??? ???? ?? ??? ???? ??? ????. ?? ?? ???????? ??? ???? SQL ?????? ??? Server ??? ?? ????? ????? ??? ??????. ???? ????? ?? ??? ???? ????????? ???????. ??? ??? ?????? ??????? ??? ???? ????????? ?????? ?????? ???? ????????? ??????? ?? ??? ?????? ????? ????? ???? ??? ?? ???? SQL.

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

?? ??? ????? SQL Server ??? ??????? ??? ????? ?? ??? ??? ???? ?????? ???? ?? ????????? ???? ????? ???? MSSQLServer ?? ???? ????? ???? ???????. ???? ???? Microsoft ??? ??????? ????? ????? ?????? ???????? ???? ???????? ???? ???? ???????? ???? ????? ???? MSSQLServer.

??? ?? ????? ????? ??????? ?????? ?? Microsoft (IIS) ??? ??????? ???? ????? ??????? SQL Server "? ????? ????? ??????? ?????" ????? ????? IIS ??? ???? ???? ???????. ??? ?? ???? ??????? ????? ???? ?? ??????? ??? ??? ?????? ?????? ??????? (FQDN) ?? ??????. ?? ????? ??????? ????? IP ???? ???????. ??? ?? ??????? ???? ??? ??????? ??? ?????? ?????? ??? FQDN ?? NetBIOS ??????. ?? ????? ??????? ????? ???????? ????? IP ????????? ???? ???? ?????? SQL Server.

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

????? ???? ????? ?? ????? REG_BINARY ?? ????? ??????? ??????:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib
???? ??? ???? ??????? ?? ?? ???? ???? ??????? ???? ????? ??????? ?? ???? ??????.

????? ? ??????? ??? ?? ???? ?????? ??? ??? ????? ???? ??????:
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib] "Certificate"=hex:2e,67,3e,84,4a,4f,e0,7f,08,42,6a,7a,35,9b,01,94,76,67,0b
??? ?? ????? ????? ??????? ??? ??? 0 ??? ???? ????????? ? ?????? ????????? ???????? ??? ?????????. ???? ??? ????? ??????? ???? ????? ??????? SQL Server ???? ?? ???? ????? ??????? ??? ?????????. ??? ??? ???? ??????? ??????? ??? ????????? ????? ????? ???, ?? ????? ????? ??????? ???.

??????? ??????? ?????? ?? ????? ????? ????? ???? ??????? ???? ?????? ??? ????? ??????? ???????? Microsoft Network Monitor ?? "????? ???? ?????" ????. ?????? ??? ???? ?? ????????? ??? ????? ????? Microsoft Network Monitor ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
243270????? ????? "?????? ??????" ?? ???? ??????? Windows 2000

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

  1. ????? ????? HTTP ??? ?????? ????? ????? ????? ?????? ???????? ?????? ???? ???? ???????? ???? ????? ???? MSSQLServer. ??? ???? ??????? ????? ????? ????? ??????:
    http://mycertserver/certsrv
    ?????? ???? Microsoft ??? ????? ?????? MSSQLServer ???????? ???? ?????? ???? ?? ???? ?????? ???? ???? ???? ???????? ???? ?????? ??????.
  2. ??? ??? ????? ?? ???? ??? ??????.
  3. ?? "?????? ??? ?????": ?????? ? ???? ?????? ?????? ??? ?? ???? ??? ??????.
  4. ??? ????? ??? ????? ??? ?????? ?????? (CA) ???????? ????? ?? ???? ??? ??????.
  5. ???? ??? ?????? ?????? ??????? ?? ???? ????????? ????? ?? ?? ?????? ?????. ????? ??? ping ??? ??? ?????? ?????? ??????? ??? ?? ??? ??????? ?? ?? ???? ????????? ????? ??.
  6. ?? ?????? ??????? ????? ????? ??????? ??? ??????? ?????? ???? ???????? ???????? - ????? ???? ??????? ?? "?????? ??????" ?????. ?????? "?????? ?????? ??????? ????? ?????? ???? ????? ?? ???.
  7. ???? ??? ?????? ????? ??????? ?? ???? ?????? ????????? ??????.
  8. ???? ???? ??????? ?????? ????????. ???? ??? ?????.
  9. ???? ?????? ??????? ?????? ????? ????? ???????. ???? ??? ????? ??? ???????.
?????? ?? ??? ????? ??????? ?????? ??? ????? MMC ?????? ?????? ?? ??? ???????? ?? ??????? ???? CertUtil.exe ??????? ??? ???? ??????? ????? ????????. ?????? ?????? ???????? ???????? MMC ???? ??????? ???????:
  1. ???? ???? ?????? MMC? ???? ??? ???? ? ?? ???? ??? ?????.
  2. ?? ???? ?????? ????? ???? mmc ?? ???? ??? ?????.
  3. ?? ??????? ???? ???? ???? ??? ?????/????? ???? ??????.
  4. ???? ??? ????? ?? ???? ??? ????????.
  5. ???? ??? ?????.

    ??? ??????? ?? ??? ?????? ???????? ?????? ??? ???? ???????? ?????? ?? ????? ?????? ?? ???? ?????????.
  6. ???? ??? ???? ?????????.
  7. ???? ??? ????????? ?????? ?? ???? ??? ?????
  8. ???? ??? ?????.
  9. ???? ??? ?????.

    ???????? ??????? ???????? ?? ???? ???????? ?? ????? ???????.
???? ????? ??????? ??? ??????? ?? ???? ?? ?? ???? ??????? ??????:
  • ????? ????? ??? ???? ???????.
  • ??? ????? ??????? ?????? FQDN ?????????.
  • ??????? ????? ?? ??????? ?????? ??????.
  • ???? ????? ??? ????? ????? ??? ?????? ?????.

????? ????? SSL ??? ???? SQL

??? ????? ??????? ??? ?????? ????? ????? ????? SSL ?????? ??????? ???????:
  1. ??????? ?????? ???????? "???? ???? SQL ?? ???? ??? ???? ???????? ??? ???????? ???????.
  2. ????? ?? ?? ?????? ????? ???? MSSQLServer "???? ?????????" ?? "???? ????".
  3. ??????? ??? ????? SQL Server ?????? ?? ?? SQL Server ?? ???? ??? ????? ??? ???????.

????? ????? SSL ????? ????

??? ?? ??? ???? ????? ????? SSL ???? ????? ?? ?????? ????? ????? ????? SSL ?? ????? ?????. ??? ????? SSL ??????? ??????? ??? ???? ????? ?? ??????. ??? ?? ????? ????? SSL ??? ???? ??? ???? ??? ?? ??? ????????? ?????? ????? ??????. ??? ?? ???? ??????? ?????? ??? ??????. ?? ????? ??????? ?????? ????? ???? ??? ?? ???? ??? ????? ?????? ?? "???? ????? ???? ?????". ???? ??????? ??????? ?????? ????? SSL ??? ???? ??? ????:
  1. ???? ?? ????? ?? ?? ?????? ????? ?????? ??? ???????? ??????? ?? "???????? ???? ??????".
  2. ????? ????? "??????" ?? ???? ??????? ???? ???????? Network Monitor ?? "????? ???? ?????" ???? ?????? ?? ????? ??????? ??? ??????? ?????? ???????.
  3. ???? ??? ?????? ?????? ??? ??? Internet Explorer ??????? ??? ??? ?????? ??? ??????? ???? ????? ??????? SQL Server.
  4. ???? ??? ?????? ?????? ??? ?????.
  5. ???? ??? ????? ??????? ?????.
  6. ???? ??? ????????.
  7. ???? ??? ??????? ??????? ????? ????????.
  8. ???? ??? ?????? ??????.
  9. ???? ??? ????? ?? ???? ??? ??????.
  10. ?? ???? ?????? "????? ??? ?????" ? ???? ??? ????? ??????? ?????? ??????? - PKCS # 7 ???????? (.P7B).
  11. ???? ?????? ???? ???????? ????? ???? ???????? ???????? ?? ???? ???????? ??? ??? ??? ??????.
  12. ??? ??? ??? ??????? ???? ?? ???????. ???? ?? ?? ???? ????? ?? ???? ?? ???? ??? ?????? ??? ???? ????????? ?????? ?????????.
  13. ???? ??? ?????? ?? ???? ??? ?????.
  14. ??? ???? ????????? ?????? ??? ?????? ???????? ????? ?? ???? ??? ?????? ?????? ??? ????? ? ??? ??? ????? ?? ???? ??? ????????.
  15. ???? ??? ????? ??????? ??????? ????? ????????.
  16. ???? ??? ??????? ? ???? ??? ?????? ? ???? ??? ??????? ?? ???? ??? ??? ??? "????? ???????": PKCS # 7 Certificates(*.p7b).
  17. ??? ??????? ???? ??? ??????? ?? SQL Server ?? ???? ??? ???. ???? ??? ??????.
  18. ???? ?????? ???? ???????? ????? ???? ???????? ?????? ??? ??? ???????? ????????.
  19. ???? ??? ??? ?????? ??????? ??????? ??? ?????? ?????.
  20. ???? ??? ?????? ?? ???? ??? ?????.
  21. ??? ??? ???? ???? ?? ????:
    ?? ????????? ?????.
  22. ???? ?? ???? ??????? ??? ??? ?????? ??????? ? ???? ??????????? ???????.
  23. ???? ??? ??? ?????? ?? ??? ???? ????? ?? ??????? ?? ?? ???????.
  24. ???? ??? ????? ??????? ???? ??????? ?? ?? ???? ?? ???? ???????? ?????? ?? ??? ??? ??? ?????? ??? ?????.
  25. ??? "???? ???? ??????" ?? ???? ??? ???? ???????? ??? ???????? ???????.

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

??????? ??????? ?? ???? ?????? ???? ????? ???????:
  • ?????? ?????? "???? ???????.
  • ?????? ?? ????? ODBC ??? ????? ????? ????? ???????.

???? ???????

??????? ???????? ???? ???? ??????? SQL ???? ??????? ???????:
  1. ??????? ??????? ?????? ???? SQL Server.
  2. ???? ?????? ???? ???????? ??? ???????? ???????.
  3. ??????? ????? ???? ????? ??????? SQL Server 2000 ???????? "???? ???????".
  4. ?????? ??????? ???????? ???? Microsoft ?????? ?? ????? ???? ?????.

??????? ODBC

??????? ?? ??? ??????? ODBC ???? ??????? ???????:
  1. ????? ????? ????? ODBC ?? OLEDB:

    ODBC
    Driver=SQLServer;Server=ServerNameHere;UID=UserIdHere;PWD=PasswordHere;Network=DBNETLIB.DLL;Encrypt=YES
    						
    OLEDB
    Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=dbNameHere;Data Source=ServerNameHere;Use Encryption for Data=True
  2. ??????? ????? ??????? ???? ????? ??????? SQL Server 2000 ??????? ??????? ???????? Microsoft Network Monitor ?? ????? ???? ?????.

?????

????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
316898????? ????? ????? SSL ????? SQL Server ???????? "???? ?????? ????????"

???????

???? ???????: 276553 - ????? ??? ??????: 06/???? ?????/1427 - ??????: 10.4
????? ???
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 64-bit Edition
????? ??????: 
kbmt kbhowtomaster KB276553 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????276553

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

 

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