Error in connecting to MSSQL server with SSL

[MaxIT]

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

[Anonymous]

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

[Anonymous]

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

Feel free to let me know if it helps.

Best regards

Sabrina

[MaxIT]

I'm using JDK 17 see attachment.

I've tried the string to no avail.

[MaxIT]

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.

[Anonymous]

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

[MaxIT]

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

[Anonymous]

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

[Anonymous]

Hello,

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

Best regards

Sabrina