Database Plug-in and domain user names for SQL authentication

book

Article ID: 5348

calendar_today

Updated On:

Products

DSERIES- SERVER CA Workload Automation DE - System Agent (dSeries)

Issue/Introduction

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