SQL backup fails with error "The login has insufficient authority. Membership of the sysadmin role is required to use VIRTUAL_DEVICE with BACKUP or RESTORE" even though the user has sysadmin permission to the database in SQL 2005

Problem

SQL backup fails with error "The login has insufficient authority. Membership of the sysadmin role is required to use VIRTUAL_DEVICE with BACKUP or RESTORE" even though the user has sysadmin permission to the database in SQL 2005

Error Message

The login has insufficient authority. Membership of the sysadmin role is required to use VIRTUAL_DEVICE with BACKUP or RESTORE

Cause

This issue is caused due to insufficient permissions to the backup account on the sql instance.

Solution

To fix this issue, make sure that the user has 'sqladmin' and 'sqlserveradmin' rights in SQL Management Studio 2005
  1. Launch the SQL Management Studio Console and go to Security-->Logins.
  2. Identfy the User that is used in Backup Exec to backup SQL 2005 Databases.
  3. Right click the User and go to Properties
  4. Select Server Roles
  5. Select serveradmin and sysadmin
  6. Rerun the backup of the SQL database

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)