I want to connect to a MS SQL database with my credentials. My user is a part of an AD group that has access to the database. How can I use my credentials to access the database?
I don’t want to use ‘integratedSecurity’ parameter since the authentication to DB fails when I deploy the workflow to server.
I assume you can use workflow credentials (right click on the workflow and set them) and prompt the user to enter them. (Unfortunately I do not have knime server to try)
br
Hi @nithinth7 , I’m assuming that you are connected to your Windows station with the same AD credentials? If so, then you can just use the None/native authentication option in the MS SQL Server Connector from Knime:
It will automatically use your Windows credentials.
EDIT: And if that is not the case, then you need to provide the user name and password of the Windows domain user you want to use for authentication. To do so please select either the Credentials option or the Username & password option. In addition, you need to specify the following entry in the JDBC Parameters tab: domain with <<Windows domain name>> as value: