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

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

Yose — Fri, 15 Nov 2024 23:27:07 GMT

Hi,

I'm new to talend and I've installed TOS for Data Integration v8.0 and MS SQL Server management studio 2012 in my Window 11 laptop. Now I'm trying to connect from TOS to MSSQL server where i'm getting below error message always and connection is not working.

Connection failure. You must change the Database Settings.

java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "The server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12]". ClientConnectionId:2ee87d53-6d69-4f7f-b990-2dd49a6e2b45

My JDK Version - jdk-17.0.1

My JRE Version - jre1.8.0_311

I've copied 'mssql-jdbc_auth-8.2.2.x64.dll' and 'mssql-jdbc-8.2.2.jre13' files to 'C:\Program Files\Java\jre1.8.0_311\lib\ext' folder.

And '

'mssql-jdbc_auth-8.2.2.x64.dll'

' file copied to 'C:\Windows\System32' folder. PATH variables also set correctly.

My connection String - 'jdbc:sqlserver://YOSUVA:1433;DatabaseName=Talend_Practice;integratedSecurity=true'

FYI - I'm using SQL windows authentication

Could you please let me know is there anything I missed and getting the above error?

Thanks in Advance

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

gjeremy1617088143 — Fri, 03 Dec 2021 08:03:06 GMT

Hi,

maybe you can add this additionnal parameter sslProtocol=TLSv1.2 in the tDBConnection component.

like this :

"integratedSecurity=true;sslProtocol=TLSv1.2"

Send me love and kudos

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

Anonymous — Fri, 03 Dec 2021 08:21:05 GMT

Hello,

It is recommended to use JDK 11 in V 8.0.1.

Here is online installation guide: TalendHelpCenter: Compatible Java Environments

Please try to set your connection string as:

jdbc:sqlserver://servername;instancename=XXXX;integratedSecurity=true;DatabaseName=XXX;enableTLS=true;sslProtocol=TLSv1.2 and go to Run tab in talend studio then in advance setting , select the "Use JVM arguments" and then click on new and paste this line.

-Djdk.tls.client.protocols=TLSv1

Let us know if it works.

Best regards

Sabrina

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

Yose — Fri, 03 Dec 2021 10:40:42 GMT

Hi,

I changed the connection string like below. still getting the same error

jdbc:sqlserver://YOSUVA:1433;DatabaseName=Talend_Practice;integratedSecurity=true;sslProtocol=TLSv1.2

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

Yose — Fri, 03 Dec 2021 10:42:49 GMT

Hi Sabrina,

I installed JDK 11 and then tried for connection testing. Still getting the same error.

This solution is not working for me even with JDK 11.

Regards,

Yose

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

Anonymous — Mon, 06 Dec 2021 04:14:15 GMT

Hello,

Could you comment on this line in java.security file on studio used JVM env? jdk.tls.disabledAlgorithms=SSLv3, TLSv1, TLSv1.1, RC4, DES, MD5withRSA,

DH keySize < 1024, EC keySize < 224, 3DES_EDE_CBC, anon, NULL, include jdk.disabled.namedCurves.

Here are references about:

https://forum.inductiveautomation.com/t/sql-server-connection-faulted/46393

https://stackoverflow.com/questions/67899129/postfix-and-openjdk-11-no-appropriate-protocol-protocol-is-disabled-or-cipher__

Feel free to let us know if it helps.

Best regards

Sabrina

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

KPratama15 — Mon, 06 Mar 2023 07:08:18 GMT

Hi,

You can add additional parameter "trustServerCertificate=true" in the tDBConnection component. It works for me.

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

Marcl78 — Fri, 07 Apr 2023 10:14:46 GMT

it just happened to me on Talend V7.3 ! i'm just very happy to find your comment. Thank you 😉