Database Connection with Instance

KNIME Analytics Platform
1

Hi,

I already connected with SQL Server Database with KNIME, however when I tried to connect with database which has instance, it failed. I tried to find the solution, but still haven’t found the solution. Please let me know if you have the solution or know the procedure to write the database name with instance.

Thank you.

Regards,
Ulfa

2

I already found the solution.

I change the URL Template in Preferences to:
jdbc:sqlserver://<host\instance>:;databaseName=[database]

I use DB Connector and type the URL Template without Port.

Thank you.

Regards,
Ulfa

1 Like
3

Thanks for posting and marking the solution! :+1:

4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.