Instance as a parameter in MS SQL DB Connection

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:

2 Likes