Re: Problems configuring SQL Server Agent Proxy

From: Stephen Dybing [MSFT] (stephd_at_online.microsoft.com)
Date: 05/22/03 

Date: Thu, 22 May 2003 09:58:39 -0700

I didn't experience any problems on SP3 basically following your procedure.
Did you try restarting SQL Server Agent? I suspect so, and I'm not sure why
that might make a difference, it's just that this isn't expected behavior,
nor is it what I'm experiencing. 

-- 
Hope this helps,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Andrew Lias" <anrwlias@hotmail.com> wrote in message
news:6d60aaf8.0305160749.2a9be759@posting.google.com...
> I am attempting to set up the Agent Proxy to allow users to run jobs
> that invoke xp_cmdshell statements.
>
> I had the proxy up an working before SP3.  After SP3, it stopped
> working.  I have gone through BOL and retraced the steps for setting
> up a proxy, without success.
>
> In brief, via EM I am:
>
> 1) Opening up the Job Systems tab of the SQL Server Agent properties
> 2) Deselecting "Only users with SysAdmin privlidges..."
> 3) Resetting the proxy (I'm setting to to be the same as the server
> agent account, which has SA privlidges and is a local admin on the
> server)
>
> I have tried giving the agent account explicit execute perms on
> xp_cmdshell (even though it's already sa).  I have tried giving the
> end user explicit exec perms.
>
> Nothing seems to work.
>
> Please, does anyone have any suggestions?  I can't afford to fork out
> the $250 for a support call to MS.
>
> --
> Andrew Lias

Relevant Pages

  • Re: Problems with SQL Srv. Agent and Proxy Account
    ... Windows Account. ... SQL Server Agent, try adding this account to the local ... >Password verification of the 'SQLAgentCmdExec' proxy ...
    (microsoft.public.sqlserver.security)
  • Reset proxy password failed
    ... When I try to reset the proxy password in the job system ... Unable to install the sql server agent proxy account ... I could reset the proxy account. ...
    (microsoft.public.sqlserver.security)