Database Plug-in and domain user names for SQL authentication

Document ID : KB000005348
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

How to set domain authentication for DB jobs using MS-SQL?

Environment:
SQL Server
Resolution:

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;domain=MyCorpDomain;databaseName=AdventureWorks;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