sqlserver jdbc driver using 5.3 knime

[Jeff_Vanderdoes]

Hi,

Likely someone can guide me on an issue after starting to use 5.3. Connecting to sqlserver I get a warning: WARN Microsoft SQL Server Connector 5:1912 Selected database driver no longer supported.

I see how to download the latest driver from Microsoft. But not sure how to install it so KNIME uses it. Any guidance?

Thanks,
Jeff

[mlauber71]

@Jeff_Vanderdoes welcome to the KNIME forum. You might want to take a look at this entry:

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? [image] 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, depen…

Also there is the documentation about how to connect to databases:

https://docs.knime.com/latest/db_extension_guide/index.html?#connect