Permissions required for a single-pass backup
To successfully perform a single-pass backup of a machine that is running Microsoft SQL Server, the account under which the backup plan runs must be a member of the Backup Operators or Administrators group on the machine.
Also, this account must be granted the sysadmin role on each of the instances installed on the machine.
If you create a backup plan while you are logged on as a regular user, such as a member of the Users group, you need to click Plan's credentials on the Create backup plan page and specify the credentials for the account that has the above privileges.
Granting the permissions to the agent
A backup plan created by a member of the Administrators group runs under the agent service account by default. The same applies to a centralized backup plan deployed from the management server.
By default, the agent service account is included in the Backup Operators group. If you choose to create a new account for the agent during installation, this account will be included in the Administrators group. Therefore, the agent always has the required permissions in Windows.
You are asked to specify the sysadmin credentials for each Microsoft SQL instance installed on the machine. This will grant the agent the sysadmin role. If you do not specify the credentials during installation, you can grant the agent the sysadmin role later by using SQL Server Management Studio or by running a T-SQL script.
To grant the agent service account the sysadmin role on an instance by means of a T-SQL script
Create Login [<machine name>\Acronis Agent User] From Windows
Exec master..sp_addsrvrolemember @loginame = '<machine name>\Acronis Agent User',@rolename = 'sysadmin'
The file can have any extension.
sqlcmd -S <machine name>\<instance name> -i <full path to T-SQL script file>
Permissions required for recovering a Microsoft SQL Server database
When recovering a database to an instance, you need to specify credentials for this instance. The prompt for the credentials appears after you select the destination instance on the Recover data page.