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

• M. Scott Blalock

  Grasshopper

  Points: 12

  More actions

  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.

• peterhe

  SSChampion

  Points: 11469

  More actions

  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.

   

• M. Scott Blalock

  Grasshopper

  Points: 12

  More actions

  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.