Products | Versions |
---|---|
TIBCO Designer | - |
Not Applicable | - |
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