none
Job failed RRS feed

  • Question

  • I am trying to copy one database from one instance to another on same computer through copy database wizard. When I click finish to execute process I receive following message. Any suggestion? Thanks

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

    Friday, October 7, 2011 9:38 PM

Answers

  • Hi DBA_LEARNER,

    For the job owner who is not a sysadmin fixed server role, you may need to create a proxy account (windows account) with permissions required to executing the package for this job step using "Run as User".

    For more information: Who owns my job and who runs it?
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    • Proposed as answer by NBOsm Monday, October 10, 2011 4:03 PM
    • Marked as answer by Stephanie Lv Friday, October 14, 2011 1:32 PM
    Monday, October 10, 2011 12:00 PM

All replies