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

[krutika_ag]

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

[cwvos]

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

[krutika_ag]

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