topic Re: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption in Data Engineering

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

Hardy — Mon, 19 Jun 2023 11:17:21 GMT

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

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

Anonymous — Tue, 20 Jun 2023 04:39:30 GMT

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.

Re: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (

DBXC — Mon, 02 Oct 2023 20:57:52 GMT

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

Re: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (

Mielios — Fri, 13 Oct 2023 07:44:28 GMT

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

Re: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (

DBXC — Fri, 13 Oct 2023 14:28:22 GMT

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;

Re: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (

Pat_IronBridges — Fri, 10 May 2024 19:28:31 GMT

Yep, that does it.