Looking for advice: Connect Microsoft SQL server using (Windows service account)

KNIME Analytics Platform
1

Hi All,

I am looking for advice, How to connect the MS SQL database using Microsoft windows service account from KNIME analytics plat form using ( DB Connector or Microsoft SQL Server Connector)

I tried using “DB Connector” and Microsoft SQL Server Connector node and configured the connection setting but it returns an error saying

ERROR Microsoft SQL Server Connector 3:553 Execute failed: Login failed for user '<username>
Background:

I was installed official MS SQL driver also verified windows service account created in MS Sql Database

DB Connector Node Setting

image
image660×592 17.1 KB

image
image819×734 62 KB

Microsoft SQL Server Connector

image
image819×746 109 KB

2

Hello @ravishing1984 ,

If you want to connect to Microsoft SQL Server please use the Microsoft SQL Server Connector node together with the KNIME Microsoft JDBC Driver For SQL Server extension.

If you want to automatically log into the database using the Windows login of the user that runs KNIME Analytics Platform you need to follow the steps native authentication.

If you want to use a username and password do not add the integratedSecurity parameter in the JDBC Parameter tab and only select the credential with the username and password in the Authentication section.

Bye
Tobias

1 Like