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: