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

All replies

  • See if links below helps you...

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/39621314-dec7-42aa-9e30-e62ea058947d/error-running-job-from-job-agent-non-sysadmin-have-been-denied?forum=sqlintegrationservices

    http://support.microsoft.com/kb/918760/en-us

    http://www.mssqltips.com/sqlservertip/2163/running-a-ssis-package-from-sql-server-agent-using-a-proxy-account/


    Thanks, Dilkush Patel Microsoft SQL Developer Support Microsoft Corporation

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

    http://www.mssqltips.com/sqlservertip/2163/running-a-ssis-package-from-sql-server-agent-using-a-proxy-account/

    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!!

    Thanks!!


    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:

    http://www.bidn.com/blogs/DonnyJohns/ssas/1705/sql-server-agent-proxy-accounts

    http://nirav.extreme-advice.com/2013/05/08/schedule-ssis-package-without-deploying/

     

    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.

    http://www.sevenforums.com/tutorials/103570-user-accounts-add-remove-groups.html?filter[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.

     

    THANKS EVERYONE!!


    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