I’m new to Knime. I am trying to connect to a MS SQL Server on localhost. I have no problem with Python or with sqlcmd. I added the Microsoft Server SQL Connector node and configured the Driver to either of the available choices: Official Driver… or jTDS for Microsoft SQL set hostname to localhost and Database name. I selected Username and Password for authentication. However the node remains Yellow and will not connect to a DB Query node. Executing the node results in No Data Available. What am I missing?

Problem connecting to MS SQL Server 2019

ipazin May 5, 2021, 1:30pm 5

have you managed to figure it out and connect or still need help? Are you running on Windows?

Additionally see here more how to troubleshot error you are seeing:

And talking about forum topics this one seems most informative about Microsoft SQL Server connection:

Br,
Ivan

1 Like