为了Encrypt connection如果安装SSL证书

Question

在Connect to Server对话框中，到Connection Properties，选中Encrypt Connection复选框，点connect,会提示错误
Client unalbe to establish connection
SSL Provider:The certificate chain was issued by an authority that is not trusted.

查选了资料，说是需要在server上安装ssl的证书，可是哪里去找那个证书呢？

Answer 1

Get it from certificate provider, or generate in windows. 

Answer 2

Could you give me a URL or a method how can I search it?

Answer 3

Just search 'certificate provider', Verisign is one of them but don't think it's free. You can generate it in windows if for testing purposes.

Answer 4

客户端和服务端都需要配置的, 你需要一个证书, 这个证书可以是你信任的证书发放机构, 你也可以自己建立证书服务器.

具体的, 你可以参考一下 sql server 联机丛书中的"如何启用数据库引擎的加密连接（SQL Server 配置管理器）"
http://msdn.microsoft.com/zh-cn/library/ms191192(SQL.90).aspx

Answer 5

首先，你得配置一个证书服务器，具体如何配置，你可参考资料如：
http://www.cnblogs.com/fypoop/archive/2004/09/14/42923.html

然后在服务器上，执行如下操作：
    1) 从证书服务器上，获得证书。通常为网页形式。如果机器名为xxxx, 那么在网页中，设name和friendly name为xxxx, Type of Certificate Needed为Server Authentication Certificate, 然后选择Store certificate in the local computer certificate store, 然后提交。
    2) 选择 Install this certificate
    3) 用mmc打开certificate on local computer. 然后在Personal Certificates就会看到新安装的certificate
    4) 重新启动SQL Server
    5) 这样，你在链接的时候，可以用Encryption=Yes来连。