Database Connection for Microsoft SQL Server on KNIME

Hi @braneev , have you tried downloading the KNIME Microsoft JDBC Driver for SQL Server extension first, and trying with the official driver?

Also, can you confirm that you are able to connect to your SQL Server database from your PC outside of KNIME? That is normally where I would begin troubleshooting connection issues, so you may already have done this, but it is useful to rule out external connectivity issues.

As @seeser has noted, there are different methods to connecting, depending on if you are using SQL Server authentication (username & password option), or “Windows Authentication” (none/native authentication option). Which authentication method is configured on your database?

btw… yes you should use the Microsoft SQL Server Connector, even with the jTDS driver. It supports both the MS drivers and the jTDS. Depending on your uses case one or other of the drivers may work better for you. You may be interested to know that the jTDS driver does have a bug concerning returning DATE datatypes.