Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question
    
Granted SQLAgent$Instance1 full rights to the e:\backups folder and still no dice. –  Sam Jun 28 '12 at 22:01

1 Answer 1

Given that you indicate you are copying to E:\Backups that it represents another server, it sounds like you are using mapped drives. Whatever agent you are using is probably being run in non-interactive logon mode, which precludes the use of mapped drives. I suggest you try to use UNC paths instead, ex: \\servername\backups

share|improve this answer
    
Yes, I didn't specify, but I am using UNC paths. –  Sam Jul 10 '12 at 16:43

Your Answer

 
discard

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.