How to resolve error '"encrypt" property is set to "true" but the driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) in TIBCO Data Virtualization?

How to resolve error '"encrypt" property is set to "true" but the driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) in TIBCO Data Virtualization?

book

Article ID: KB0070047

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization All supported versions

Description

When trying to connect to the SQL server adapter, the below exception message can be seen:
----------------------------------------------------------
at "jdbc:sqlserver://TIBCO-PF33RJF9\SQLEXPRESS:1433;databaseName=TestDB;selectMethod=direct".  Make sure the URL information, user name and password are correct.  [datasrc-3961025]
"encrypt" property is set to "true" but the driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption: Error: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target.
-----------------------------------------------------------

Environment

All supported environment

Resolution

This issue happens because the encrypt property is set to true. To address this, encryption can be disabled by modifying the connection URL. Follow these steps to resolve the issue:
1. Open the SQL server data source and within the data source configuration, locate and select the "Advanced" tab. This section typically contains various advanced settings and properties related to the database connection.
2. In the "Advanced" tab, under the field 'connection URL pattern,' the connection URL can be specified or modified. This URL is used by the application to connect to the SQL Server database. It should be updated to include the encrypt=false property to disable encryption.
For example: jdbc:sqlserver://<HOST>:<PORT>;databaseName=<DATABASE_NAME>;selectMethod=<SELECT_MODE>;encrypt=false
3. After updating the connection URL, Save the changes in the data source configuration. Once saved, test the connection to ensure that it is now successful​​​​​.

Issue/Introduction

This article guides in resolving an exception message that may arise when working with SQL server adapter in TIBCO Data Virtualization.
Powered by Wolken Software