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

[Yose]

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

[gjeremy1617088143]

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

[Anonymous]

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

[Yose]

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

[Yose]

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

[Anonymous]

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...

Feel free to let us know if it helps.

Best regards

Sabrina

[KPratama15]

Hi,

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

[Marcl78]

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