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

?? ??? ?? ??? ???? ????? ???? ?? ?? ???? ?? ??? ?? 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>).
   • ????? ?????????????? ????? ??, ????? ??? ?????? ??? ?? ????????????????? ??.

?? ?????????? ??? ?? ???? ?? ???? ???? ?? ??, ??? ?????? ???? ?????? ???