Summary
integratedSecurity=true
This tells the instance to use integrated authentication when making the JDBC connection.
Release
All versions
Instructions
Go to the JDBC connection record (jdbc_connection.do)
There are 2 ways in which to modify the Connection URL to include this:
1) Change the "Format" to "-- None --" and adding the Connection URL
ie. jdbc:sqlserver://<Server>;selectMethod=cursor;databaseName=<Database name>;integratedSecurity=true
The drawback is that you won't able to use "Test Connection" in the activity designer and have to use "Test Inputs" to test.
OR
2) Run a background script to modify the "connection_url" field in the record to include "integratedSecurity=true".
This method still allows the "Test Connection" to be used. The only drawback is if you modify the JDBC Connection record, it may reset the connection URL and you will have to modify the field again to include Integrated Authentication.