Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Location
    Galway, Ireland
    Posts
    3

    Cool Unanswered: Setting up a SQL Agent Proxy Account

    Hello everybody.
    I am having a strange problem on a SQL server when setting up a SQL Agent Proxy account to allow non SysAdmin users to run scripts and CMDShell procedures. I have tried on other 3 servers and works a treat. On this specific one, not a chance. I was wondering if anyone could give me a step by step tip on how to set this up and what to check in order to come up with a solution (before I clean the box and reinstall everything from scratch).

    Any help would be greatly appreciated
    Max Cottica

  2. #2
    Join Date
    Jun 2003
    Posts
    31
    In The EM, right click the SQL Server Agent and select Properties.
    then make sure under the "Job System" panel & Non-System Admin Job Step Proxy Account, the option "Only User with SysAdmin..." is not checked. When this option is unchecked, the Proxy account will be allowed to run CMDEXEC.

    SVT

  3. #3
    Join Date
    Jan 2003
    Location
    Galway, Ireland
    Posts
    3
    SVT,
    spot on ! Thanks a bunch.
    Max

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •