The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption

Hardy
New Contributor III

I am trying to connect to SQL through JDBC from databricks notebook. (Below is my notebook command)

val df = spark.read.jdbc(jdbcUrl, "[MyTableName]", connectionProperties)
println(df.schema)

When I execute this command,

with DBR 10.4 LTS it works fine. But after upgrading to DBR 13.0 it throws below error:

SQLServerException: 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:XXXXXXXX-XXXXX-XXXXX-XXXXX-XXXXXXXXXXXX

Caused by: SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

Caused by: ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

Caused by: SunCertPathBuilderException: unable to find valid certification path to requested target