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

All replies

  • See if links below helps you...

    Thanks, Dilkush Patel Microsoft SQL Developer Support Microsoft Corporation

    Monday, October 14, 2013 12:19 AM
  • Thanks!  I believe this is the key.

    That error message is exactly the same as the one I'm getting!  However, when I go through the steps in that link, I get an error on Step #2. 

    Step #1 works fine.  I ran it EXACTLY as it appears in the link.  When I run Step 32, I get this.

    Msg 14529, Level 16, State 1, Procedure sp_add_proxy, Line 45
    Proxy "ARSHADALI-LAP\SSISProxyDemoUser" is not a valid Windows user.
    Msg 14262, Level 16, State 1, Procedure sp_verify_proxy_identifiers, Line 51
    The specified @proxy_name ('SSISProxyDemo') does not exist.

    I don't understand what the error is, so I can't get past this step.  Any ideas how I can move forward on this anyone?  I've been working on this darn problem for a couple weeks now!!


    Knowledge is the only thing that I can give you, and still retain, and we are both better off for it.

    Thursday, October 17, 2013 11:06 PM
  • Hello experts.  I finally got this working!!  Hallelujah!!

    Here’s how I did it.  I went through the steps in these two links:


    Also, and this was the missing link for oh so long . . . you need a dang User account!!  I thought I could use my default, but for some reason, which I never quite figured it out, that never worked for me.  I finally had the forethought to create a brand new account, assign a password, and re-try running the project.  Follow the steps here to create your User Account.[2]=User%20Accounts



    After creating the User Account, and adding a new password, run through the steps in the first two links I posted. 



    Argh!!  Frustrating!!  I was so close, and so very far away too!!

    Well, with some help from the kind people here, as well as applying persistence and perseverance, I got it working.



    Knowledge is the only thing that I can give you, and still retain, and we are both better off for it.

    Sunday, November 17, 2013 8:47 PM