SQL Server connection issue

[chaithuj]

We are using Knime 4.7.0. We are trying to connect to SQL Server using Active Directory Authentication.

As suggested in some of the posts
If we use JDBC Driver (jTDS for Microsift SQL server) we are getting this error
" TLS version being less than minimal TLS version allowed by the server"

We tried to enable JDBC Parameters for TLS 1.1and 1.2 and that didn’t work.

Then we downloaded latest JDBC version 12.8 and tried to connect
we get the error " Driver is nor configured for integrated Authentication"

Please help, we are new to Knime and we use it for testing and we don’t have any dev support

[mlauber71]

@chaithuj is it possible that you would have to use credentials to log into the database?

Set DB Connector Login via Flow Variable – tobias.koetter

I can't use Flow variables as Credentials in Get Request nodes

I did get this message. That’s good to know, thanks. That solved my issue. For some reason I saw (and used) the Credentials option on the NTLM Tab, as it was specified in another forum post linked in my first message, but not in the Basic tab. Silly me. So here is the correct configuration [image] Thanks to everyone who took time to help me !

[izaychik63]

Hope this will help

[chaithuj]

Thank you, it worked