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

[Hardy]

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

[Anonymous]

Hi @Hardy S​ 

Great to meet you, and thanks for your question!

Let's see if your peers in the community have an answer to your question. Thanks.

[DBXC]

Anyone has update on this? I am seeing the same issue with DBR 12.2

[Mielios]

Also seeing this issue after upgrading to DBR 12.2. Any news is very much appreciated!

[DBXC]

Try to add the following parameters to your SQL connection string. It fixed my problem for 13.X and 12.X

;trustServerCertificate=true;hostNameInCertificate=*.database.windows.net;

[Pat_IronBridges]

Yep, that does it.