使用加密= yes，则SQL Server连接字符串 - ＆GT; ＆QUOT;提供商：SSL提供程序，error：0 - 证书的CN名称不匹配所传递的价值＆QUOT; [英] Using Encrypt=yes in a Sql Server connection string -> "provider: SSL Provider, error: 0 - The certificate's CN name does not match the passed value."

问题描述

我用加密= YES SQL Server连接字符串中，因为我需要的TCPIP数据流进行加密，但在打开连接我得到一个错误：

I'm using Encrypt=yes in a SQL Server connection string, as I need the TCPIP traffic to be encrypted, but on opening the connection I get an error:

A connection was successfully established with the server, but then an error
occurred during the pre-login handshake. (provider: SSL Provider, error: 0 -
The certificate's CN name does not match the passed value.)

任何建议如何解决这一问题？我想我需要某种形式的我的服务器之间的证书的关系，但不知道从哪里开始。

Any suggestions how to fix this? I assume I need some sort of certificate relationship between my servers, but have no idea where to start.

我需要这两个连接，每一个到SQL 2000服务器和一个2005年的服务器。

I need this for two connections, one each to a SQL 2000 server and one to a 2005 server.

推荐答案

您可以配置数据库连接进行加密，并接受来自服务器的任何证书。没有盛大的解决方案，但它为我工作。

You can configure database connection to be encrypted and to accept any certificate from server. Not a grand solution, but it worked for me.

连接字符串应该是这样的：

Connection string would look like this:

"[...];Encrypt=True;TrustServerCertificate=True"

这篇关于使用加密= yes，则SQL Server连接字符串 - ＆GT; ＆QUOT;提供商：SSL提供程序，error：0 - 证书的CN名称不匹配所传递的价值＆QUOT;的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！