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.