Unable to peform redirect restore of Microsoft SQL 2008 database to a path.

Article:TECH214239  |  Created: 2014-01-22  |  Updated: 2014-01-22  |  Article URL http://www.symantec.com/docs/TECH214239
Article Type
Technical Solution


Issue



Unable to peform redirect restore of Microsoft SQL 2008 database to a path.


Error



Final error: 0xe0001683 - Access is denied (MS SQL restore).
Final error category: Security Errors

For additional information regarding this error refer to link V-79-57344-5763


Environment



Backup Exec 2010 R3 SP2

Microsoft SQL 2008


Cause



The account used to peform the restore does not have sufficient permission on SQL Server Instance.


Solution



Confirm that the account used to protect (Backup and Restore) Microsoft SQL data should have Administrator rights on the SQL server as well as the SQL databases.

Also make sure that the user has 'sqladmin' and 'sqlserveradmin' rights in SQL Management Studio.

Note: See the related article section for more information.


Supplemental Materials

SourceUMI
ValueV-79-57344-5763



Article URL http://www.symantec.com/docs/TECH214239


Terms of use for this information are found in Legal Notices