Intermittent JDBC Connectivity Error with SQL server: SQL Server returned an incomplete response

Intermittent JDBC Connectivity Error with SQL server: SQL Server returned an incomplete response

book

Article ID: KB0079550

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks 5.x

Description

How to resolve following intermittent JDBC Connectivity error while connecting to SQLServer Database:
+++++++++++
"JDBC error reported: (SQLState = 08S01) - com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server returned an incomplete response. The connection has been closed. 
++++++++++++

Environment

ALL

Resolution

Update the JDBC Driver to 4.2 or later version
Remove old jar files (sqljdbc4.jar, sqljdbc41.jar) so that BW can loads the correct one (sqljdbc42.jar).

Issue/Introduction

Intermittent JDBC Connectivity Error with SQL server: SQL Server returned an incomplete response

Additional Information

https://blogs.msdn.microsoft.com/dataaccesstechnologies/2016/11/30/intermittent-jdbc-connectivity-issue-the-driver-could-not-establish-a-secure-connection-to-sql-server-by-using-secure-sockets-layer-ssl-encryption-error-sql-server-returned-an-incomplete-respons/