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
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.
SAP Knowledge Base Article - Preview