Error “com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset” while establishing connection to MS SQL Server 2008 R2 with force encryption flag set to true.

Error “com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset” while establishing connection to MS SQL Server 2008 R2 with force encryption flag set to true.

book

Article ID: KB0090674

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks -
Not Applicable -

Description

Resolution:
Description:
========
TIBCO Businessworks 5.9.3 or higher using TRA version 5.7.3 or 5.7.4, is not able to connect to ‘MS SQL Server 2008 R2’ with exception com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset. This is related to JRE version 1.6.0_28 or higher (tested with 1.7.0_09).

Environment:
========


TIBCO Businessworks 5.9.3 or higher, TRA 5.7.3 or TRA 5.7.4 .

All Supported Operating Systems.
JRE 1.6.0_28 or higher.

Resolution:
=======
Use JRE version 1.6.0_27. Install JRE 1.6.0_27 in an external directory and modify the tra to use the newly installed JRE.

Issue/Introduction

Error “com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset” while establishing connection to MS SQL Server 2008 R2 with force encryption flag set to true.