How to connect Knime to Azure SQL Server

emanoelasantos · December 20, 2023, 3:21pm

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 ?

Daniel_Weikert · December 20, 2023, 4:49pm

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

emanoelasantos · December 20, 2023, 5:30pm

Hi,

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.

system · March 19, 2024, 5:30pm

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