How can I connect a DataBase of MS SQL SERVER to KNIME?

Hi,

I’m trying to know how connect a database of Microsoft SQL Server to Knime with the node of Microsoft SQL Server Connector? I do not know really well how to configure the node? Where do I have to search on Microsoft SQL Server to configure the node?

Please, I really need help for this.

Hello @LilianaGarcia ,

have you checked Database Guide? Each configuration field is explained in it and there is even examples on how to connect to some databases including Microsoft SQL Server.

https://docs.knime.com/latest/db_extension_guide/index.html#connect

Seems you should start from there and then ask if you don’t manage to connect or have a specific configuration question :wink:

Br,
Ivan

@LilianaGarcia

That’s all there is to it:

But I would recommend using the official Microsoft SQL driver, I had quite a few problems with the default driver. The microsoft sql driver can be installed as a knime extension:

1 Like

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