search cancel

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

book

Article ID: 201480

calendar_today

Updated On:

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