This is an archive version of the document. To get the most up-to-date information, see the current version.Required Permissions
The following table lists required permissions for user accounts to back up and restore Microsoft SQL Server data.
Operation | Required Roles and Permissions |
|---|---|
Veeam Explorer launch | Account under which Veeam Explorer for Microsoft SQL Server runs must be a member of the local Administrators or Users group. |
Backup | For more information, see the Required Permissions section of the Veeam Backup & Replication User Guide. |
Restore, Instant Recovery | Account being used must be a member of the local Administrators group and must be granted the sysadmin role on the target Microsoft SQL Server. For more information about Microsoft SQL Server roles, see this Microsoft article. |
Staging Microsoft SQL Server configuration | 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. |