Error when trying to execute a Database Job

Document ID : KB000090370
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error when trying to execute a Database Job
Resolution:

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

  • Longon ,Database User and Server is set to Windows Authentication
  • The Password credentials in the Database do not match with the Password set for database user in Automic.
  • Automic system is connecting to that database but the Forms tab functionality wasn't properly installed

Solution

  • Set the Authentication of the Database so it can be used for SQL-User Authentication
  • Change the Password to match the credentials, or change the Password credentials on Database so it accepts the password used for the User.
  • Check if you have done all the Steps in our Documentary given for the Agent installation.