How to set domain authentication for DB jobs using MS-SQL?
The JDBC URL can be configured to allow domain authentication for SQL Server. The JDBC can be updated in the agentparm.txt on the agent side. The JDBC URL can also be specified at the job level as well. The following is an example that will allow user authentication against a domain.
jdbc:sqlserver://localhost:1433;databaseName=<database name>;domain=<domain name>;integratedSecurity=true
Note: If JDBC URL is modified in the agentparm.txt then the agent must be restarted. Also, the jTDS driver will need to be added. It is recommended to download and add the latest driver to <agent_install_dir>/jars/ext