Backup of the SQL database fails with the error "Database query failure"

  • Article ID:100022371
  • Modified Date:
  • Product(s):

Problem

Backup of the SQL database fails with the error "Database query failure"

Error Message

An error was encountered while attempting to browse the contents of Microsoft SQL Server. Database Query failure. See the job log for details.

The Backup exec debug log on the SQL server shows the following error:
SQL Error Description: Login failed for user 'Domain\administrator'. Reason: The account is disabled.
 
NOTE: The above error may also occur while selecting the database in the backup selections.

Cause

Backup of SQL database may fail with the above mentioned error message if the Default logon account used to connect to the SQL server has been disabled in the SQL server Logins. 


 

Solution


1. To resolve the issue enable the User account in SQL server login and try the backup/selection again.
 

 

 

 

Related Articles

How to troubleshoot An error occurred on a query to database" or "Database Query Failure errors that occur during a backup or restore.

Was this content helpful?

Get Support