topic Re: com.microsoft.sqlserver.jdbc.SQLServerException:The driver could not establish a secure connection to SQL Server by using SSL encr. Error: "Unexpected rethrowing" in Data Engineering

com.microsoft.sqlserver.jdbc.SQLServerException:The driver could not establish a secure connection to SQL Server by using SSL encr. Error: "Unexpected rethrowing"

Michael_Galli — Tue, 05 Apr 2022 14:55:48 GMT

Hi all,

there is a random error when pushing data from Databricks to a Azure SQL Database.

Anyone else also had this problem? Any ideas are appreciated.

See stacktrace attached.

Target: Azure SQL Database, Standard S6: 400 DTUs

Databricks Cluster config:

"spark_version": "9.1.x-scala2.12",

"spark_conf": {

"spark.driver.extraJavaOptions": "-Dlog4j2.formatMsgNoLookups=true",

"spark.sql.session.timeZone": "UTC",

"spark.driver.maxResultSize": "6g",

"spark.executor.extraJavaOptions": "-Dlog4j2.formatMsgNoLookups=true",

"spark.databricks.io.cache.enabled": "true"

"node_type_id": "Standard_E4ds_v4",

"driver_node_type_id": "Standard_E8ds_v4",

Re: com.microsoft.sqlserver.jdbc.SQLServerException:The driver could not establish a secure connection to SQL Server by using SSL encr. Error: "Unexpected rethrowing"

User16741082858 — Tue, 05 Apr 2022 17:01:29 GMT

This is related to cipher algorithm config occasionally failing during the handshake. As an immediate workaround I'd recommend trying to update to the latest JDBC driver which has a newer JRE which has some TLS cipher suite config updates which might mitigate the issue ( cf https://java.com/en/configure_crypto.html#TLSCipherSuiteOrder ) and also set the TLS version explicitly to 1.1 in the connection string.

Here is the latest version - https://github.com/microsoft/mssql-jdbc/releases/tag/v10.2.0

Re: com.microsoft.sqlserver.jdbc.SQLServerException:The driver could not establish a secure connection to SQL Server by using SSL encr. Error: "Unexpected rethrowing"

Michael_Galli — Wed, 06 Apr 2022 08:02:16 GMT

Thx Pearl.. we already use mssql-jdbc 10.2.0 (from Maven library com.microsoft.azure:spark-mssql-connector_2.12:1.2.0)

Re: com.microsoft.sqlserver.jdbc.SQLServerException:The driver could not establish a secure connection to SQL Server by using SSL encr. Error: "Unexpected rethrowing"

Michael_Galli — Wed, 20 Apr 2022 06:07:57 GMT

@Pearl Ubaru

TLS 1.1 is already deprecated.

Are there any concerns from your side to set TLS 1.2 in the connection string?

Re: com.microsoft.sqlserver.jdbc.SQLServerException:The driver could not establish a secure connection to SQL Server by using SSL encr. Error: "Unexpected rethrowing"

User16741082858 — Thu, 21 Apr 2022 14:43:11 GMT

Hi @Michael Galli. No there should be no concerns. What DBR version are you using?

Re: com.microsoft.sqlserver.jdbc.SQLServerException:The driver could not establish a secure connection to SQL Server by using SSL encr. Error: "Unexpected rethrowing"

Michael_Galli — Thu, 21 Apr 2022 14:58:24 GMT

@Pearl Ubaru DBR 9.1 LTS, because we are using com.microsoft.azure:spark-mssql-connector_2.12:1.2.0

Re: com.microsoft.sqlserver.jdbc.SQLServerException:The driver could not establish a secure connection to SQL Server by using SSL encr. Error: "Unexpected rethrowing"

User16741082858 — Thu, 21 Apr 2022 15:56:12 GMT

Yes then you are fine. The DBR must be 8.4+ for TLS 1.2