SQL Server Rights to backup drive
Posted
by
Sam
on Server Fault
See other posts from Server Fault
or by Sam
Published on 2012-06-28T21:50:05Z
Indexed on
2012/07/04
3:17 UTC
Read the original article
Hit count: 528
I'm trying to copy a backup I've made from one server to another using either an SSIS or Powershell step in a job. I've run into the same error on both systems when running the step under the sql agent. I receive errors that the path does not exist. I've tried granting the agent rights to e:\backups, where the file is located, but it still doesn't work.
When I use a proxy for the step, it works fine.
Can anyone help me with what permissions to grant to sqlagent?
Rights look to have been granted to MSSQL$Instance1 on the backup drive.
© Server Fault or respective owner