How to connect Knime to Azure SQL Server

HI all,

I’m trying to connect Knime to Azure Sql Server, but it’s been almost impossible.

Is there anyone that could connect successfully ?

What is the error?
What authentication is used?
Azure SQL Server has public internet access?


Yes, the DB has public access from my ip.

I’m using ActiveDirectoryIntegrated authentication.

The error message is: Execute failed: Failed to load both mssql-jdbc_auth-12.4.2.x64 and MSAL4J Java library for performing ActiveDirectoryIntegrated authentication. Please install one of them to proceed.

I have already check and the mssql-jdbc_auth-12.4.2.x64.dll is inside of my java path.

Find attached the configurations I’m using to connect.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.