Article ID: 316779 - View products that this article applies to.
This article was previously published under Q316779
Clients that have the Force Protocol Encryption option set ON on the client may fail to connect to SQL Server if clients specify an IP address for the server name.
If you try to connect from Query Analyzer, the error message that occurs is:
If you try to register the server from the SQL Enterprise Manager, the error message that occurs is:
Unable to connect to server 'ip_address' Sever: Msg 18, Level 16 State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB] SSL Security error
SSL Security error ConnectionOpen(SECDoClientHandshake())
To work around this problem, you can use either of these methods:
(https://support.microsoft.com/kb/318605/EN-US/ )INF: How SQL Server Uses a Certificate When the Force Protocol Encryption Option is Set On
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Microsoft is researching this problem and will post more information in this article when the information becomes available.
You turn on the Force Protocol Encryption option by using the SQL Server Client Network utility.
For additional information about how to configure SQL Server to use certificates, click the article number below to view the article in the Microsoft Knowledge Base:
276553If a client fails to connect to SQL Server and this error message occurs
(https://support.microsoft.com/kb/276553/EN-US/ )HOW TO: Enable SSL Encryption for SQL Server 2000 with Certificate Server
you need to make sure that SQL Server is restarted after the certificate is installed on the server that is running SQL Server.
Encryption not supported on SQL Server
Article ID: 316779 - Last Review: June 13, 2003 - Revision: 4.3