Is it possible to configure a JDBC workflow activity to use Integrated Windows Authentication?

[Mark244]

I am trying to create a new JDBC workflow in the Activity Designer to call a stored procedure on a MS SQL Server.  However, the JDBC Activity requires a credential, which I believe only utilizes SQL authentication, and I need to use Windows authentication.  Is there a way to configure the JDBC workflow activity to either use integrated  authentication of the Windows account the MID Server service is running under, or specify a Windows domain, user account and password in the credential?

[Mike Patel · Accepted solution]

This is old post if someone else searches for it. you can add ;integratedSecurity=true to your jdbc connection (jdbc_connection.list) you can edit connection url in list view only.

jdbc:sqlserver://<Server>;selectMethod=cursor;databaseName=<Database name>;integratedSecurity=true

[Niamul Arifin]

@Mike Patel  I have tried using the integratedSecurity=true in the connection URL but still its not working. I am getting a Authentication Failed message.

Question: if i use this property in the connection string, do I have to provide JDBC credential with the JDBC Connection record? 

Question: I see there is a checkbox called Use Integrated authentication available if i go from Data source >> New >> . I am trying to test the JDBC connection via windows AD authentication to MSSQL server creating a JDBC connection and JDBC credential record.

Midserver is installed in server1 and MSSQL hosting server in server2. They both can talk to each other. 

Overall goal for this integration so that service catalog variables values can be inserted to the MSSQL DB. 

Can you provide some guidance here please?