Home / server / Questions / 52782
Accepted
Sam
Asked: 2009-08-12 07:02:28 +0800 CST

Let SQL write a backup to a workstation's directory

  • 772

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?

Thanks!

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.

windows sql-server security

2 Answers

  1. Best Answer

    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.

    • 5

  2. 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.

    • 0