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
| Article:TECH68586 | | | Created: 2009-01-09 | | | Updated: 2012-06-29 | | | Article URL http://www.symantec.com/docs/TECH68586 |
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
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
- Launch the SQL Management Studio Console and go to Security-->Logins.
- Identfy the User that is used in Backup Exec to backup SQL 2005 Databases.
- Right click the User and go to Properties
- Select Server Roles
- Select serveradmin and sysadmin
- Rerun the backup of the SQL database
|
|
Related Articles
Legacy ID
320803
Article URL http://www.symantec.com/docs/TECH68586
Terms of use for this information are found in Legal Notices
Thank you.