???? ID: 316898 - ????? ???????: 04 ?????? 2010 - ??????: 2.0

Microsoft ??????? ????? ?? ????? ?? ?? SQL ????? ??????? ?? ??? SSL ??????????? ????? ???? ?? ??? ???? ????

?????? ??????This article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

?? ????? ??

??? ?? ??????? ???? | ??? ?? ??????? ????

??????

?? ??? ?? ??? ???? ????? ???? ?? ?? ???? ?? ??? ?? Microsoft SQL Server 2000 ?? Microsoft SQL Server 2005 Microsoft ??????? ????? (MMC) ?? ????? ???? ??? ?? ????? ??, ?? ????????? ??????? ?? ??? SSL ??????????? ????? ???? ?? ??? ???? ?? ????? ???? ?? ?? ???? ???????? ?? ??? ?????? ???? ??????? ?????

???:SQL ????? ????? ????? ?? ??? ?????? ???? ?? ???? ?? ??? ?? ?? ???? ?? ????? ???? ???? ?? ???? ???

??? ???? ????? ???? ??????????? ?????? ???? ??????? ?? ???? ???? ??? ??, ?? ?? ?? ???? ??? SQL Server ??????-???? ????? ?? ??? ?????????? ?????? ????, ?? ??????? ??????? ???? (SSL) ??????????? ?? ??? ?????????? ?? ????? ?????

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

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

????????????? ?? ??????? ??????? ?????? ?? ????? ???? SSL ??????????? ????? ??, ?? ?? ??????? ?? ??? ??????? ???? ?????? SSL ??????????? ???? ?? ??? ??? SQL ????? ?? ?? ??????? ?????? ?????

???????:??? ?? ????? ????????????? ??????????? ?? ????? ??????????? ???????? ?? ?? ?????? ???? ?? ???? SQL ????? ?? ????? ????????? ?? ??? ?? ??????? ??????? ??? SQL ????? ?? ????? ??????? SSL ??????????? ?? ???? ????????

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

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

???:??? ?? SQL Server 2005 SQL Server 2005 ?? ?? ?????? ?? ??? ???????????? ????????? ?? ????? ???? ?? ??? ????? ??? ?? ??? ??, ?? ?? ?? ??? ??? ?? ???? ???ForceEncryption???? ?? ??? ?????????. ???? ??????? ?? ??? ????? "????: ??????? ????? (SQL ????? ??????????? ???????) ?? ??? ??????????? ??????? ?? ????? ????" ???? SQL Server 2005 ????

Microsoft ??????? ????? (MMC) ?? ??? ???? ????? ?? ??? ?????? ???? ??????? ????

SSL ??????????? ?? ????? ????, ?? ???? ?????? ???? ?? ????? ?? ??????? ???? ????? Microsoft ??????? ????? (MMC) ?????-?? ?? ????? ?? ?????? ???? ?? ??????? ???? ?? ???, ????? ????? ?? ???? ?????

MMC ?????-?? ?? ???????? ???? ????
  1. ?????????? ?????-?? ?? ????? ?? ??? ????? ????? ?? ???? ????:
    1. MMC ????? ?? ????? ?? ??? ????? ????????????? ????-????? ????, ?? ???? ????????. ??????????????? ????? ?? ??????:

      MMC
    2. ????? ????????????? ??,?????/??????? ?????-??....
    3. ????? ????,add?? ????-????? ????, ?? ???? ????????? ????. ????? ????,add???:?
    4. ?? ?????-?? ??????? ?????????? ???? ?? ???, ???? ????, ?? ???????? ???? ?? ??? ????? ?? ??? ??? ???? ??? ???????????????? ????.
    5. ??? ??????????? ?????????? ????-????? ????, ?? ???? ?????????.
    6. ????? ????,??? ??????????????????? ?????-?? ??????????? ????? ?? ??????? ?? ??? ?? ..
    7. ????? ????,OK??????????/??????? ?????-??????? ????? ?? ??????? ?? ??? ?? .. ???? ??????? ?????? ???? ??? ????? ????????? ?????????? ???????????????????? ?? ????
  2. Use the MMC snap-in to install the certificate on the server:
    1. ?? ??? ???? ?? ??? ????? ?????????????folder in the left-hand pane.
    2. Right-click in the right-hand pane, point to??? ??????? ????-????? ????, ?? ???? ???Request New Certificate....
    3. TheCertificate Request Wizard????? ????? ??? ???? ??? ????? ????,next. ??? ????Certificate type is "computer".
    4. ?????Friendly Nametext box you can type a friendly name for the certificate or leave the text box blank, and then complete the wizard. After the wizard finishes, you will see the certificate in the folder with the fully qualified computer domain name.

    5. If you want to enable encryption for a specific client or clients, skip this step and proceed to the???? ??????? ??????? ?? ??? ??????????? ????? ?????? ???? ?? ????

      ??? ????? ?? ??????????? ????? ???? ????? ???, ?? ????? ??????? ?????? ?? ????? ?? ???? ?????????? ??????? ??, ?? ???? ??? ?? ??? ???? ?? ??? ?????????????? ??????????? ?? ????? ??????? ?????. ??????????? ?? ??????? ???? ?? ??? MSSQLServer (SQL Server) ???? ?? ???????? ????? ?? ???? ????? SSL ??????????? ?? ????? ???? ?? ??? ????? ???

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

??????? SSL ??????????? ?? ?????? ???? ?? ??? ??????? ???????? ????? ?????? ???? ?? ??????? ???? ????? ?? ????? ?? ?????????? ???? ?? ????? ???? ?????? ????????? ??? ?????????? ?????????? ?????? ????? ?????? ???? ????? ??????? ???? ?? ??? MMC ?????-?? ?? ????? ???? ?? ??? ???:
  1. ????? ?????????? ????????? ??? ?????????? ?????????? (CA) ?? ??????? ???? ?? ??? ????? ????? ?? ???? ????:
    1. MMC ?????, ?? ???? ??? ??? ???? ?????? ???? ?? ?????? ?????????????????????.
    2. ?????? ???? ?? ??? ????-????? ????, ?? ???? ????????.
    3. ????????????????? ??TAB. ??? ????? ??????? ???? ????
    4. ???? ?? ??? ??????? ????????????? ??? ?????????? ?????????????????, ?? ???? ??? ???? ??? ???? ??? ?????? ???? ??????? ?? ?????? ????? ??? c ???...
    5. ????-????? ????CA?? ????? ????,??? ??????? ????-????? ????, ?? ???? ??????????.
    6. ??????? ??? ?? ??? ????, ?? ?? ???? ????? ???? ??????? ???????? ????? ??? ?????? ?? ???? ??? ????????? ????? ?? ???????
  2. ??????? ???????? ?? ?????? ???? ?? ???? ???? ?? ???, ????? ????? ?? ???? ????:
    1. MMC ?????-?? ?? ????? ???? ??????? ???????? ?? ??????? ????, ?? ?? ???? ?? ??? ??????? ????????????? ??? ?????????? ?????????????????.
    2. ????-????? ????????????? ??? ?????????? ?????????????????, ?? ??? ???????? ??????? ????-????? ????, ?? ???? ??????? ????.
    3. ??????? ????, ?? ???? ??? ?????????? ?? ??? ???? (.cer ?????) ?? ???? ??? 1 ??? ????? ???? ??? ??? ???????? ?? ??? ??? ?? ???? ???? ?? ??? ??????? ?? ??? ?????
    4. SQL ????? ??????? ??????? ?????? ?? ????? ?????
    5. ?? ??? ???? ?? ??? ????? ????????????? ??????????? ?? ????? ??????????? ?? ???? ??????? SSL ??????????? ?? ????? ???? ?? ??? ????? ???

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

?? ?? ?? ?? ???? ??? ???? ??????? ??????? ?? ???? ????:
  • ?????? ???????? ????? ?? ????? ?????

    -??-

  • ?? ????? ??? ODBC ????????? ???? ?? ??????? ???????? ??? ???? ????
?????? ???????? ?????

To use the Query Analyzer Tool, follow these steps:
  1. SQL ????? ??????? ??????? ?????? ?? ????? ?????
  2. ?? ??? ???? ?? ??? ????? ????????????? ??????????? ?? ????? ???????????
  3. Connect to the server that is running SQL Server 2000 by using Query Analyzer.
  4. Monitor the communication by using Microsoft Network Monitor or a Network Sniffer.
ODBC or OLEDB Application Sample Connection Strings

If you use ODBC or OLEDB connection strings, follow these steps:
  1. Modify the ODBC or OLEDB connection string. ?????? ?? ???::

    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. Connect to the server that is running SQL Server 2000, and then monitor the communication by using Microsoft Network Monitor or a Network Sniffer.

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

After you successfully install the certificate, the certificate does not appear in the?????? ?????? ?????????? ??????? ?? ????? ????..

???:The?????? ??????? ??? ???? ??? ?????????<instancename></instancename>???????? ????? ?? SQL ????? ??????????? ??????? ?? ???? ???

?? ?????? ???? ?? ??????? ?? ?? ???? ?? ???? ??? ??????? ?????? ?????? ????? ??? ?????? ???? ?????? ??, ?? ??? ???? ???????? ???? ???????? ??????? ?? ????? ????.. ??? ????? ?? ???? ??? ?????????? ?? ?? ??????? ????? ??, ????? ????? ?? ???? ????:
  1. ?????????? ?????-?? ?????? ??? ???? ?? ???, ??? 1 ??? "MMC ?????-?? ?? ???????? ???? ?? ??? ???? ????" ??? ??????
  2. ?????????? ?????-?? ???, ??????? ?????????????, ?? ???? ??? ??????? ?????????? ????.
  3. ???? ??? ???, ?? ?? ??????? ?????? ???? ?? ?????? ??????
  4. ????????? ???? ?? ???? ?????????? ????? ?????????? ???? ???? ??:
    • ???? ??? ???, ??? ????????? ?????????? ?????????? ?? ??? ????? ???? ?????? ??????? ??????????.
    • ???? ??? ???, ??? ??????? ???? ???? ???????? ????? ?? ??? ???? ?????? ???
  5. ?????? ???? ???-????? ????, ?? ???? ??? ????????? ???? ?? ???? ?????????? ????? ?????????? ???? ???? ??:
    • ????? ?????????????? ??, ???? ????? ????? ????? ??:
      ???? ??? ??? ???? ????? ?? ?? ?????????? ?? ???? ???
    • ????? ????????????, ?? ??? ???????:?????? ??? ????? ??? ???? ?????? ???
    • ??? ?? ???????????? ????? ?????????? ???? ?????? ??????? ??????? (<number></number>).
    • ????? ?????????????? ????? ??, ????? ??? ?????? ??? ?? ????????????????? ??.
?? ?????????? ??? ?? ???? ?? ???? ???? ?? ??, ??? ?????? ???? ?????? ???

???? ???? ???? ??:
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 64-bit Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Workgroup Edition
??????: 
kbhowtomaster kbmt KB316898 KbMthi
???? ?????? ???????????? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:316898  (http://support.microsoft.com/kb/316898/en-us/ )