Configuring DB connector to Microsoft SQL Server DB

Need help configuring the DB connector node to my Microsoft Database. Some assistance please, especially on the Driver name and Database URL section

Hello @vamadoya,

and welcome to KNIME Community!

There is official KNIME DB documentation you can check. Under examples you’ll find one related to MS SQL Server:

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

Br,
Ivan

1 Like

Connecting to MSSQL.docx (164.4 KB)

Hello @ipazin not successful yet. I have attached a snippet, kindly assist

Hello @vamadoya,

hostname seems unusual. You can check Microsoft documentation how to build URL:

Additionally you can check KNIME documentation about DB extension:
https://docs.knime.com/latest/db_extension_guide/index.html?pk_vid=7afaa7730384d0a217153268003ebaf2#intro

Br,
Ivan

1 Like