Sign up ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I need to write a backup to a workstation directory.

I've granted the sql service domain account read/write/modify rights to the directory.

Msg 3201, Level 16, State 1, Line 2
Cannot open backup device '\\ws10000\c$\temp\Auditor.bak'. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 2
BACKUP DATABASE is terminating abnormally.

If I grant the service account admin rights to the machine it completes successfully.

What additional rights do I need to grant?


edit: I'm thinking that maybe the account needs to be admin in order to use the c$ (admin) share. I'll try creating a share.

share|improve this question
Take a look at how I am doing this… – MarlonRibunal Aug 19 '09 at 23:58

2 Answers 2

up vote 5 down vote accepted

The c$ share is a special administrative share. Try creating a new share on your workstation and granting the account SQL is using access to it instead.

share|improve this answer
This thought just came to mind - and I think it's probably the issue. – Sam Aug 11 '09 at 15:10

Scheduled backups run as the SQL Server Agent. The agent needs rights to write to the machine that you want to store data on. What user does the agent run as, compare and assign the appropriate permissions and you should be ready to go.

share|improve this answer
FYI - Running the backup interactively needs the service account to have rights. – Sam Aug 11 '09 at 15:12

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.