SQL Connection

KNIME Analytics Platform
1

Hello,
I am new to KNIME and trying to connect Microsoft SQL Server connector but unable to create the connection. I have updated all drivers but still having issue.Please can someone share a steps how to complete this task.
Thanks

2

Look at examples workflows here

1 Like
3

Hi @masadlatif , welcome to the KNIME forum.

From past experience of troubleshooting such connection problems, it is most helpful if you can tell us:

  • which version of KNIME you are using, and on what OS
  • what you have attempted so far (ideally with screenshots but remember to obscure any private information such as host names/ip addresses and credentials)
  • what authentication mechanism you are using (windows authentication or sql server authentication)
  • which specific jdbc driver you are using
  • whether you have explicitly installed the ms sql server extension
  • whether you can connect to the database using a tool other than KNIME (and which tool)

… And probably most importantly what error message(s) you are seeing.

Thanks.

2 Likes