Connect to Azure SQL Database Managed Instance via KNIME

[mcrisnidh]

Hello KNIMERs,

This is something I have done a few years ago but I cannot remember how it is supposed to be done.

I have a Azure SQL Database Managed Instance and I access to my database there.
Its not an authentication issue I believe, since I can access to my data through Microsoft SQL Server Management Studio, and the same user and password Im using in KNIME with the node “MySQL Connector”, but I get the error:
“Execute failed: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.”

Any suggestions are truly appreciated. Thank you everyone in advanced and hope this post helps people to resolve their issues as well.

[marvin.kickuth]

Hi @mcrisnidh ,

It looks like we may not have a JDBC driver bundled to connect to MySQL / Azure SQL. This is usually the case due to licensing restrictions. You can download the appropriate driver (in your case likely from here) and then register the JDBC driver in KNIME (step-by-step guide).

Hope this helps!

Kind regards
Marvin

[marvin.kickuth]

Hi @mcrisnidh ,

Quick addition: for SQL Server we also have a dedicated connector which may work out of the box, saving you the extra step from registering a JDBC driver:

Microsoft SQL Server Connector

Kind regards
Marvin

[mcrisnidh]

This one did it. I put the right credentials and the server’s name, and it works. Thank you so much!