SQL job failure with error "Invalid or empty password specified"

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - System Agent (AutoSys)
• Workload Automation Agent
• CA Workload Automation AE

Issue/Introduction

Job fails with error "Invalid or Empty Password specified" reported in transmitter.log file of the agent.

This is the job definition example:

insert_job: Testjob    job_type: sqlagent

machine: machine-name

sqlagent_target_db: msdb

sqlagent_jobname: jobname

sqlagent_server_name: SQL-SERVER-NAME\INST01

sqlagent_user_name: username

sqlagent_domain_name: domain-name

Environment

Release : 11.4 

Component : CA Workload Automation AE Agent 

Resolution

Problem resolved by configuring the user as well as defining the config\sql\msdb.properties

java:jtds:sqlserver://sql-server-name;instanceName=inst01;databaseName=msdb