Backup of the SQL database fails with the error "Database query failure"
An error was encountered while attempting to browse the contents of Microsoft SQL Server. Database Query failure. See the job log for details.
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.
1. To resolve the issue enable the User account in SQL server login and try the backup/selection again.