Execute failed: Login failed for user

[mohammad_alqoqa]

I am trying to make a link between knime and microsoft sql server, the problem I am facing is that if I use db connector the link is done. But if I use microsoft sql server connector the problem appears as in the pictures

I am using the latest version of knime 5.3

Note: The settings are limited in microsoft sql server connector not as I saw in the older discussions in the forum.

[mlauber71]

@mohammad_alqoqa the text in the last screenshot says the driver version is no longer supported. So you might want to get a newer one.

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

[mohammad_alqoqa]

I did the steps. But I can’t complete the last step because the driver class field remains empty. And when I click on search, there is no change.
I searched the web but I didn’t get a result.
Any help?

[mlauber71]

@mohammad_alqoqa maybe this thread can help.

Configuration node Microsoft SQL Serverc Connector

Hello, I was able to find the indicated drivers (photo 1) [1] But even if the connector nod is configured (photo 2) [2] I get the following result: Execute failed: Execute failed: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: “SQL Server did not return a response. The connection has been closed. ClientConnectionId: abb675c3-b05d-49e1-af84-0fcd7b55f58c”