SAP Knowledge Base Article - Preview

3465124 - Error: "encrypt property is set to "true"...PKIX path building failed" appears when creating a relational connection to MS SQL Server in Information design tool

Symptom

  • Below error appears when trying to test a JDBC relational connection to MS SQL Server in Information design tool:

    “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:

    Sun.security.validator.ValidatorException: PKIX path building failed:

     

    Sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target.”

  • SSL encryption is not used.


Read more...

Environment

  • SAP BusinessObjects Business Intelligence 4.3 SP4
  • MS SQL Server 2022
  • JDBC driver 12.2 for SQL server

Product

SAP BusinessObjects Business Intelligence platform 4.3

Keywords

SSL, BI 4.3, sql, IDT, jdbc, certificate , KBA , BI-BIP-IDT , Information design tool , BI-BIP-IDT-CX , Connection Layer , 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.