Hi I am using Knime Analytics Version 4.4.1. I try to connect to Azure Database using Ms SQL Server Connector and found an error as below attached. I have checked, Azure sql database has been set with minimum TLS 1.0. Do you have any suggestions to fix this issue? [19.09.2021_14.43.29_REC]

Hello, since this problem did come up more often lately, this is a problem with an outdated Microsoft SQL Server instance and KNIME using a newer Java version which by default does not support TLS 1.0 and 1.1 anymore due to security concerns. For details see: [JDK-8256490] Release Note: Disable TLS 1.0 and 1.1 - Java Bug System However you can re-enable it, at your own risk, by re-enable the versions by removing “TLSv1” and/or “TLSv1.1” from the jdk.tls.disabledAlgorithms security property in the java.security configuration file. You can find the file in the <KNIME_FOLDER>/plugins/org.knime.binary.jre.win32.x86_64_<VERSION>/jre/conf/security folder. Bye Tobias

Hi @kengdeb a similar question has been discussed in another thread yesterday: Unable to connect to SQL Azure DB using DB Connector - #2 by wkhan

Hello Marten Thks for your reply. I looked at your comment and find some difficulty to link what mentioned in Microsoft page (trustServerCertificate, String connectionUrl) to Knime configuration. Do you have any suggestion where can I get more information especially on how to configure this in Knime Analytics Platform?

I don’t think you need to adjust any of the database settings, but just use the latest, official MS jdbc driver. Here you can find additional information on how to add jdbc drivers in KNIME AP: KNIME Database Extension Guide

KNIME Forum Archive

SQL server connector TLS version

KNIME Analytics Platform

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled