I am trying to connect to a MSSQL database with server name as: prod-companyx-workplace-resources.database.windows.net with a specific login creds and a database name. If I use a Microsoft SQL Server Connector node it gives me : ERROR Microsoft SQL Server Connector 0:16 Execute failed: Client driver version is not supported. How would I go about solving it!

Hi there @shubhamss , glad to see you found a workaround! To connect to Azure SQL Database from KNIME check this topic: [image] Connect to Azure Database KNIME Analytics Platform Hello, I am using Knime and I would like to connect to the Azure Database. I tried the Microsoft SQL Server Connector node and encountered an error. ERROR Microsoft SQL Server Connector 0:1 Execute failed: Failed to load ADAL4J Java library for performing ActiveDirectoryPassword authentication. I have downloaded the ADAL4J from Microsoft including the dependencies and also the JDBC driver from Knime installation marketplace. I have tried the following: Create a plugin and include t… Br, Ivan

Database MSSQL Connection error

KNIME Analytics Platform

ipazin May 13, 2020, 5:10pm 5

Hi there @shubhamss,

glad to see you found a workaround! To connect to Azure SQL Database from KNIME check this topic:

Br,
Ivan