JDBC Test Connection fails with BW-JDBC-100034 for Microsoft SQL server .

JDBC Test Connection fails with BW-JDBC-100034 for Microsoft SQL server .

book

Article ID: KB0087768

calendar_today

Updated On:

Products Versions
TIBCO Designer -
Not Applicable -

Description

Resolution:
Description:
============
JDBC Test Connection fails with BW-JDBC-100034 for Microsoft SQL server .

=================
BW-JDBC-100034 "Configuration Test Failed. Exception [com.microsoft.sqlserver.jdbc.SQLServerException] occurred.
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."."
=================

Customer gets the preceeding error even if the database is not using SSL.

Environment:
===========
TIBCO Runtime Agent(TRA) 5.6.x ,
TIBCO Designer 5.6.x ,
TIBCO ActiveMatrix BusinessWorks 5.8.x


Cause:
========
TIBCO_SECURITY_VENDOR is not set to the correct value.
  
Resolution:
===========
Add the following property to the designer.tra file.

         java.property.TIBCO_SECURITY_VENDOR=j2se

Issue/Introduction

JDBC Test Connection fails with BW-JDBC-100034 for Microsoft SQL server .