Database Plug-in and domain user names for SQL authentication

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;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