Connect to ms sql server using user credentials in KNIME Server

database
#1

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

0 Likes

#2

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


Bye
Tobias

0 Likes

#3

@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

0 Likes

#4

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

0 Likes

#5

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

0 Likes