Connect to ms sql server using user credentials in KNIME Server

[nithinth7]

Hi All,

I would like to know what are the possibilities to connect to ms sql server using user credentials in KNIME Server. The aim is to make database connection in Server as same as the database connection in analytics platform using windows authentication. There were multiple post regarding analytic platform, but couldn’t find any posts that related to KNIME Server. Any help would be really appreciated!!!

Regards,
Nithin

[tobias.koetter]

Hello Nithin,
please have a look at the following thread:

Server Configuration for MS SQL Active Directory Authentication

I’ve been reading through connect to ms sql server by windows authentication and need some consolidated advice. We are using KNIME server for a POC and I want to use SQL AD authentication. However, we are using server-side configuration for our KNIME end-users. Would the guide above (the very last post) when applied to the server work to make AD authentication work?

Bye
Tobias

[nithinth7]

@tobias.koetter

Assume that the Server is using windows athentication to log user in (maybe using impersonation).
If the server is hosted on a Linux system, and the user logging-in from a windows system, what are the possibility to use the windows credentials for database connection?

Regards,
Nithin

[tobias.koetter]

Hello Nithin,
if the KNIME Server runs on Linux you would need to enable Kerberos based authentication for the SQL Server and setup constraint delegation on the KNIME Server. For further detail how impersonation works have a look at the Big Data documentation where this is explained for the Hive database.
Bye
Tobias

[nithinth7]

@tobias.koetter Thank you very much!! I will check those solutions.