Access is denied. Msg 3013. when restoring database from a network drive

if you are trying to restore a database from a backup file that is on a network server…

the sql server service needs to be running under a domain account that has privileges to the network share you are trying to retrieve the backup file from.

when selecting the domain user account in sql server service, you need to make sure that you are selecting domain users from the entire directory.  change this by clicking the “location” button inside the “select user or group” dialog box.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.