Hi KNIMEers , I am facing an issue connecting to MS SQL Server . Its weird , i am able to connect to MS SQL server where the instance name is default “i.e SQL Express” But i am facing an IOException error when i try to connect to MS SQL with an instance name which is not default. I am guessing its because of the instance. All the permissions are granted and the ports are open still i am unable to connect. How to pass instance as a parameter in DB node, what is the syntax ? Please help.

Thanks @Suhas . Is your SQL Server database running on a different machine to where you are running Knime? You said you can connect to it with the default instance name of SQL Express, but not when it is a different instance name… I think instance name on SQL Server can be passed as a parameter on the jdbc driver. In which case you could try adding “instance” as a jdbc parameter on the node, as shown here: [image]

Instance as a parameter in MS SQL DB Connection

KNIME Extensions

ipazin May 25, 2021, 1:37pm 6

Hello @Suhas,

maybe this post helps:

Br,
Ivan

1 Like