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."

Question

Hi geniuses (is that genii?)

I'm using 'Encrypt=yes' in a Sql Server connection string, because i need the tcpip traffic to be encrypted, but on opening the connection i get the 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.

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

Thanks a lot in advance.

Answer 1

Here's (mainly for my reference) a bunch of links i've accumulated:

http://blogs.msdn.com/b/sql_protocols/archive/2005/10/04/476705.aspx1 http://support.microsoft.com/kb/2765532
http://support.microsoft.com/kb/3168983

I've tried to follow their instructions, but get a "Certificate types are not available" error when trying to make the certificate request in the Certificates MMC snapin.