Microsoft Authenticator and Microsoft SQL Server Connector

[thor_landstrom]

Hello @Alberto_Ruggeri,

I believe you need to manually download the latest drivers for this to work.

See below:

Connection to Azure SQL with MFA Authentication

Hello Andrew, you can use a new function in the JDBC driver to get the token and do the authentication. To do so you need to register the latest driver and some additional jars which is all explained in this workflow: Once the driver is registered you can use the component from the workflow to establish the connection. To make this easier we are planning to add a dynamic input port to the Microsoft SQL Server Connector node to pass in the token from the the Microsoft Authentication node. By…

Also here below:

Microsoft Authentication and Azure SQL DB Access

I can’t answer the first part but I think the Azure SQL issue can be fixed by using the Official Microsoft JDBC Driver for SQL Server. You need install it, but it’s easy using then Install Extensions menu. I use Azure SQL and KNIME without issues using this.

Hope this helps,
TL