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?