SAP Knowledge Base Article - Preview

3703634 - [Cloud Integration Only] Failed to obtain JDBC Connection, when "trustServerCertificate" property is set to false

Symptom

An error occurs when attempting to connect to a Microsoft SQL database through JDBC in iFlow. The error message is:

org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: "encrypt" property is set to "true" and "trustServerCertificate" property is set to "false" 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. ClientConnectionId:904469b6-2b78-4f44-9b49-c66c3ee7f3ff, cause: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target.


Read more...

Environment

  • SAP Cloud Integration
  • SAP Integration Suite

Product

Cloud Integration all versions ; SAP Integration Suite all versions

Keywords

jdbc connection error, pkix path building failed, ssl certificate validation, trustservercertificate, encrypt property, jdbc adapter, cloud connector, integration suite, sql server connection issue, java trust store, self-signed certificate, CPI, Failed to obtain JDBC Connection; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: "encrypt" property is set to "true" and "trustServerCertificate" property is set to "false" but the driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption: Error: PKIX path building failed, cpi, CPI, Cloud integration, Integration suite. , KBA , LOD-HCI-PI-CON-JDBC , JDBC Adapter , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.