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!!!
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?