Permissions

The following table lists the required permissions for user accounts to restore Microsoft SQL Server data.

Operation

Required Roles and Permissions

Veeam Explorer for Microsoft SQL Server launch

The account used to run Veeam Explorer for Microsoft SQL Server must meet the following requirements:

  • The account must be a member of the local Administrators or Users group.
  • The account must have the Veeam Backup Administrator or Veeam Restore Operator role on the backup server.

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.

 

Page updated 11/9/2023

Page content applies to build 12.1.2.172