U2012031 The database driver returned the following error message;Login failed for user

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Affects Release version(s): 6.00A

U2012031 The database driver returned the following error message;Login failed for user

Environment

Release:
Component: AAUTEN

Resolution

Detailed Description and Symptoms

While trying to Execute a Database job the following error returns:

U2012031 The database driver returned the following error message;
  Login failed for user "user"

Investigation

There are 3 Possible errors

1.) Trying to longon with an Database User and Server is set to Windows Authentication

2.) The Password credentials in Database do not match with the Password set for database user in Automic.

3.) Automic system is connecting to that database but the Forms tab functionality wasn't properly installed

Solution

1.) Set the Authentication of the Database so it can be used for SQL-User Authentication

2.) Change the Password to match the credentials, or change the Password credentials on Database so it accepts the password used for the User.

3.) Check if you have done all the Steps in our Documentary given for the Agent installation.