All Apps and Add-ons

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

krutika_ag
Engager
"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? 

Labels (1)
0 Karma

cwvos
Loves-to-Learn

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

0 Karma

krutika_ag
Engager

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

0 Karma
Get Updates on the Splunk Community!

Detecting Remote Code Executions With the Splunk Threat Research Team

WATCH NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If exploited, ...

Enter the Splunk Community Dashboard Challenge for Your Chance to Win!

The Splunk Community Dashboard Challenge is underway! This is your chance to showcase your skills in creating ...

.conf24 | Session Scheduler is Live!!

.conf24 is happening June 11 - 14 in Las Vegas, and we are thrilled to announce that the conference catalog ...