topic Re: Error in connecting to MSSQL server with SSL in Installing and Upgrading

Error in connecting to MSSQL server with SSL

MaxIT — Fri, 15 Nov 2024 22:24:57 GMT

Hi, I've just installed TOS v 8.0.1 on a Windows server.

While creating the DBConnection to the MSSQL 2019 server I've received the attached error message.

I'm attaching the metadata configuration as well.

Do you have any suggestion? Please note I'm using JDBC 11.2.0.jer17.jar

Thanks in advance,

Max

Re: Error in connecting to MSSQL server with SSL

Anonymous — Mon, 31 Oct 2022 03:29:44 GMT

Hello,

What's JDK version are you using?

Please try to use the following connection string;

jdbc:sqlserver://servername;instancename=XXXX;integratedSecurity=true;DatabaseName=XXX;enableTLS=true;sslProtocol=TLSv1.2

Best regards

Sabrina

Re: Error in connecting to MSSQL server with SSL

Anonymous — Mon, 31 Oct 2022 03:30:23 GMT

Hello,

You could try to 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 me know if it helps.

Best regards

Sabrina

Re: Error in connecting to MSSQL server with SSL

MaxIT — Wed, 02 Nov 2022 11:39:50 GMT

I'm using JDK 17 see attachment.

I've tried the string to no avail.

Re: Error in connecting to MSSQL server with SSL

MaxIT — Wed, 02 Nov 2022 11:41:20 GMT

I've commented the the line in the attached security file to no avail.

Please let me know if I had to change the connection string.

Re: Error in connecting to MSSQL server with SSL

Anonymous — Thu, 03 Nov 2022 04:53:31 GMT

Hello,

In addition to that, Java 17 is not list in the compatible java environment for V 8.0.1

Please use Java 11 instead.

Here is online documentation about: TalendHelpCenter: Compatible Java Environments

Best regards

Sabrina

Re: Error in connecting to MSSQL server with SSL

MaxIT — Thu, 03 Nov 2022 16:44:01 GMT

Hi, I could use Java 11. Please note I was able to use Java 17 with Talend 8.0.1 on a different installation.

Anyway I doubt I'd solve my problem with the SSL connection.

Still in need of support.

Thanks,

Max

Re: Error in connecting to MSSQL server with SSL

Anonymous — Fri, 04 Nov 2022 05:19:17 GMT

Hello,

As you install JDK on your machine, Java comes with its own trust store (collection of a certificate from well known CA like Verisign, goDaddy, thwarte etc.

you can find this file inside JAVA_HOME/JRE/Security/cacerts where JAVA_HOME is your JDK Installation directory.

Please make sure you are using the compatible Java environment in your studio V 8.0.

In the documentation we provide a list of Java environments that are supported, in the sense that we do provide an SLA and technical support for them. This doesn't mean other (non-listed) Java environments will not work but simply we won't necessarily be equipped to help you with any issue you may face with them.

Best regards

Sabrina

Re: Error in connecting to MSSQL server with SSL

Anonymous — Wed, 09 Nov 2022 03:48:52 GMT

Hello,

Is there any update for your issue? Feel free to post your issue and concern here.

Best regards

Sabrina