topic Error while connecting to Azure SQL Managed Instance in Talend Data Catalog

Error while connecting to Azure SQL Managed Instance

MaxIT — Fri, 15 Nov 2024 22:20:17 GMT

Hi, I'm compelled to use Studio version 6.0.

While trying to connect to Azure SQL Managed Instance I received the following error message:

java.lang.RuntimeException: java.sql.SQLException: Reason: Login failed due to client TLS version being less than minimal TLS version allowed by the server.

See attached file for further details.

Any clue?

Thanks,

Max

Re: Error while connecting to Azure SQL Managed Instance

Anonymous — Thu, 24 Nov 2022 02:07:03 GMT

Hello @Max Agostinone

Regarding to the error log, This is caused by the default jTDS driver version 1.2.2 not supporting TLS 1.2.

The possible solution:

Download a Microsoft JDBC driver that supports JRE 8 and TLS 1.2 , Microsoft JDBC
import the downloaded mssql-jdbc.jar by Window->show view -> Talend->Modules view in the studio
Change JDBC Provider to 'Microsoft' for the MSSQL connection as the below

Re: Error while connecting to Azure SQL Managed Instance

MaxIT — Thu, 24 Nov 2022 08:39:53 GMT

Hi, thanks for the answer.

Please note it's Studio version 6.0 and I'm not alone working with it.

Doesn't installing the new jar run the risk of creating issues with the other projects currently running with the jtds-1.3.1.jar?

Thanks,

Max

Re: Error while connecting to Azure SQL Managed Instance

Anonymous — Thu, 24 Nov 2022 09:34:05 GMT

Hello @Max Agostinone ,

Thanks for the feedback.

could you please check if JDBC Provider is setup to "Open source JTDS" for the MSSQL connection? if yes, then it's currently running with jtds-1.3.1.jar.

then just try to change it to "Microsoft" to test if it work?

it's not necessary to install the new jar if it doesn't popup a dialog to install the missing mssql-jdbc.jar.

Best regards

Aiming