Required Permissions

In this article

    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.