SQL Restore fails with - User does not have permission to RESTORE database 'DATABASENAME'.

Problem

Running a SQL Restore fails with very little byte count and an error indicating there is insufficient permissions.

 

Error Message

V-79-65323-3110 - User does not have permission to RESTORE database 'DATABASENAME'.

 

Cause

This can occur if the System Logon Account doesn't have the neccessary SQL permissions even if the account being used to run the restore does.

 

Solution

Give the System Logon Account the neccessary SQL permissions, or change the System Logon Account to one which does.

See the following article:

Understanding Logon Accounts and required User Rights Assignment to resolve connection, backup or restore failures

www.symantec.com/docs/TECH130255

 


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)