topic Re: Splunk DB Connect Error: Error: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderExceptio in All Apps and Add-ons

Splunk DB Connect Error: Error: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: u

krutika_ag — Mon, 26 Feb 2024 12:03:05 GMT

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

Any suggestions?

Re: Splunk DB Connect Error: Error: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderExceptio

cwvos — Tue, 07 May 2024 13:50:05 GMT

Where you able to get past this error? If so what was the resolution as I am facing the same issue now.

Re: Splunk DB Connect Error: Error: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderExceptio

krutika_ag — Wed, 08 May 2024 07:54:05 GMT

Hi, yes I was able to get past this issue,

I edited the JDBC URL and added below additional KV pairs

jdbc:sqlserver://IP:Port;databaseName=dbname;selectMethod=cursor;encrypt=false;trustServerCertificate=true

Hope this helps

Re: Splunk DB Connect Error: Error: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderExceptio

aagro — Fri, 31 May 2024 12:08:51 GMT

Your solution is right:

jdbc:sqlserver://IP:Port;databaseName=dbname;selectMethod=cursor;encrypt=false;trustServerCertificate=true

I resolve my issue, thank a lot