Post reply

Issue: OS Cmd in Job Step, Mapped drive/Agent Priv probem

  • February 21, 2005 at 6:53 am

    #88125

    I need to do an Xcopy command in a job step which has a persistant mapped network location as the source drive. When I run the xcopy in a dos box (logged in as Machine Admin), the statement runs file. When I run the statement in a job step in SQL Server (agent uses system account) I get a privilidge error on the network drive. I even changed the agent to run under the machine admin account with the same results.

    Any thoughts? Thanks in advance.

  • February 22, 2005 at 6:55 am

    #543450

    I think you need to use a domain user account that can access the mapped drive as the proxy account.

     

  • February 23, 2005 at 5:09 am

    #543657

    Thanks Peter for the idea. I will try changing to a domain admin, but the system admin (which is the agent's account) is in the domain admin group and the system admin can execute the dos command interactively in a dos box. Thanks again.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply