Jobs

• anithagovindarajalu

  SSC Eights!

  Points: 981

  More actions

  February 18, 2009 at 3:36 am

  #197287

  Hi,

  For DB Upgradation, I took the job script from SQL 2000 and executed in SQL server 2005. One of my job fails and getting the below error.

  Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account. The step failed.

  Can any one please help me how to resolve this?

  Thanks,

  Anitha

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  February 18, 2009 at 7:40 am

  #945922

  Who is the owner of this job? If its not sa then read about creating proxy accounts at http://technet.microsoft.com/hi-in/library/cc966397(en-us).aspx

  MJ