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: 533

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

Related posts about windows-server-2008

Related posts about sql-server