KNIME 4.4 - DB Connector or DB SQl Server Connector Error

Hey guys.

I downloaded the new version of KNIME 4.4 and tried to use my connection nodes with MS SQL Server.

I noticed that in the new one we only have the jTDS driver and not the Official Driver anymore.

I downloaded and installed the latest driver from the Microsoft website and tried to run my workflow.

however I came across the following error:

2021-07-04 22:58:47,128 : ERROR : KNIME-Worker-15-Microsoft SQL Server Connector 4:4:0:6 : : Node : Microsoft SQL Server Connector : 4:4:0:6 : Execute failed: This driver is not configured for integrated authentication. ClientConnectionId:04a56b60-4f3a-4bab-8929-247b4d746803
com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication.

I tried it with version 8 of the drive and got the same error.

I tried also removing the option intergrateSecure = True.
but it doesn’t work either.

could they help?

Hi,
due to license restrictions you need to install the JDBC driver from Microsoft separately via this extension:

Bye
Tobias

3 Likes

Hello @tobias.koetter thank you very much

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