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

Document ID : KB000089374
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Affects Release version(s): 6.00A

U2012031 The database driver returned the following error message;Login failed for user
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.