CA WA Agent: SQL Plug-In Authentication and changing domain passwords

book

Article ID: 143062

calendar_today

Updated On:

Products

CA Workload Automation Agents CA Workload Automation Agent

Issue/Introduction

In CA WA Agent for MS-SQL (MS-SQL plugin), if the Windows domain authentication is used then user and password may be set at the manager/scheduler side.  A default user with password may also be set in the properties file (target_database.properties).

Cause

Jobs may fail if the password has expired.

Environment

Release : 11.5

Component : CA WORKLOAD AUTOMATION AGENT FOR MS-SQL

Resolution

As per organizational security policy, the password will have to be updated periodically.  The password for user will have to be updated manually in the manager/scheduler side.  

If the db properties file is used on the agent side, then use the agent password utility to encrypt the password and then update the properties files.