Symptoms
Application-aware backup of SQL databases finishes with the following warning:
Cannot get the file list of Microsoft SQL database '...'.
Cause
The account used for Microsoft SQL Application-aware backup does not have the 'sysadmin' role on the Microsoft SQL instance.
Solution
Check that the user account is added to SQL Server security logins and that it has the "sysadmin" role for the SQL instance:
- Using SQL Management Studio, connect to the SQL instance.
- Go to Security -> expand Logins
- Open account properties and switch to Server Roles
- Mark the sysadmin check box
- Reattempt the backup
If the solution does not help, collect Acronis System Information from the affected machine and contact Acronis Support with reference to this article.