After upgrading the Instance and MID Server, loading records from the JDBC Datasource failed with the below error:

"MID Server reported error: java.sql.SQLException: 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. ClientConnectionId:e431e5d4-2acb-48c3-8b5b-c52bfca4bb11"



1. Find out the Java version used by the MID Server.

  • To check the version, Run this in MID Server > Scripts - Background by selecting the appropriate MID Server from the dropdown
  • You can find the "java.version=" in the results.

2. Find out the SQL Server version of the target where the JDBC Datasource queries.


Java version 1.8+ uses TLS 1.2 by default

TLS 1.2 is supported only from SQL 2008 and higher versions which cause the SSL exception.

Reference -


Request the SQL admins to create a new view/instance/node on a different server which is of version 2008 or higher so that the TLS version Supports. 

Article Information

Last Updated:2020-04-15 09:22:43