KNIME 4.5 MS SQL Server 2019 and again it doesn't work

[PatrikS]

Hallo,
A few days ago I had updated to 4.4 and then to 4.5. As expected, no connection to the SQL server can be established again. Last time the problem could only be solved after months with a JAVA programmer. This can not be it.

I have reinstalled and integrated the current drivers from Microsoft. As in the old version, I used the following jar file. mssql-jdbc-9.4.0.jre8.jar

When I open the workspace, I immediately get the following message:
WARN Microsoft SQL Server Connector 0:82 DB Connection no longer available. Go to advanced settings to enable connection restoration.

If I run the Microsoft SQL Server Connector I get the following error message:
ERROR Microsoft SQL Server Connector 0:51 Execute failed: Dieser Treiber ist nicht für integrierte Authentifizierung konfiguriert. ClientConnectionId:ddae3cf9-f02a-4bc5-a4c1-c2e250115dfc

integratedSecurity = true is set.

Patrik

[PatrikS]

I have it up and running again. I did not install the extension MS SQL Server because old drivers were installed here that did not work with SQL Server 2019. Now the current drivers are installed.

[tobias.koetter]

Hello @PatrikS ,
with KNIME Analytics Platform version 4.5.0 we have updated the driver in the SQL Server extension to the latest version 9.4.0. The driver includes all files that are required for native authentication and authentication with Azure Active Directory. So once you install the extension everything should work out of the box.
Sorry for the inconveniences.
Bye
Tobias