Unable to Connect Microsoft SQL Server after upgrading the SQL server to handle the TLS vulanarabilities
Article ID: KB0081225
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | - |
Description
When we try to connect to Microsoft Server 2012 - connection fails with following error after we upgrade the Sql server to handle the TLS . Vulanarabilites
Cause: The driver could not establish a secure connection to SQL Server by using Secure Sockets
Layer (SSL) encryption. Error: "SQL Server did not return a response. The connection has been
closed.".
Cause: The driver could not establish a secure connection to SQL Server by using Secure Sockets
Layer (SSL) encryption. Error: "SQL Server did not return a response. The connection has been
closed.".
Issue/Introduction
When we try to connect to Microsoft Server 2012 - connection fails with following error
Cause: The driver could not establish a secure connection to SQL Server by using Secure Sockets
Layer (SSL) encryption. Error: "SQL Server did not return a response. The connection has been
closed.".
Resolution
One of the requirements is to need to upgrade the drivers for TLS 1.2 support for Microsoft SQL Server. For the CIS to be connected to SQL server ,the application driver has to be upgraded 1)The version which supports TLS 1.2 should be available in https://support.microsoft.com/en-ca/help/3135244/tls-1-2-support-for-microsoft-sql-server. 2) And also need to upgrade the TDV/CIS JRE to latest. upgrade jre7 to jre8. As soon as you download the drivers, Go to "Client component downloads" once you have clicked the above link and then download the jdbc driver and copy it in to adapter folder<<CIS install directory>>\conf\adapters\system\microsoft_sql_server_2012. and then restart the server and test further.
Attachments
Feedback
Yes
No
Powered by
