The following table lists required permissions for user accounts to back up and restore Microsoft SQL Server data.
Required Roles and Permissions
Veeam Explorer for Microsoft SQL Server launch
The account used to run Veeam Explorer for Microsoft SQL Server must be a member of the local Administrators or Users group.
Restore, Publish, Instant Recovery
The account must be a member of the local Administrators group and must be granted the sysadmin role on the target Microsoft SQL Server. To learn more about Microsoft SQL Server roles, see this Microsoft article.
The sysadmin role is required for connections with Microsoft SQL Server Virtual Device Interface (VDI) that Veeam Explorer for Microsoft SQL Server uses to perform recovery operations. For more information, see this Microsoft article.
Staging Microsoft SQL Server configuration
The account used to connect to the staging server must be a member of the sysadmin role on the Microsoft SQL Server.
If you want to use a local Microsoft SQL Server as a staging server and Veeam Explorer for Microsoft SQL Server runs under an account that does not belong to the local Administrators group, you must specify the current account for connection to the staging server, or you will get an impersonation error.
For more information on how to configure and use the staging Microsoft SQL Server, see Configuring Staging SQL Server.