Problems configuring SQL Server Agent Proxy

From: Andrew Lias (anrwlias_at_hotmail.com)
Date: 05/16/03 

Date: 16 May 2003 08:49:55 -0700

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: Cannot view merge agent properties (to log errors)
    ... If I look at the jobs (Management/SQL Server ... Agent/Jobs) I can't see one that seems to match this merge agent. ... subscription job appears in this folder on the subscriber, ...
    (microsoft.public.sqlserver.replication)
  • Re: NTLM Proxy locking user account
    ... Proxy is made by Bluecoat, & you load proxy agent on the server that will ... Sorry just found the logs on server that is running the agent for NTLM ...
    (microsoft.public.windows.server.active_directory)
  • Re: Merge Agent wants to use proxy, but no proxy is needed
    ... I think the problem is not the proxy here. ... I believe this failure is when the merge agent is running for the first time ... The Merge Agent failed to connect to the Internet proxy server ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL2005 - Snapshot agent wont start
    ... Unable to start execution of step 2 (reason: JobOwner flowersj doesn't have ... permissions to use proxy 1 for subsystem Snapshot). ... so I tried to change the Snapshot Agent to use this acct as well. ...
    (microsoft.public.sqlserver.replication)
  • Creating jobs remotely
    ... database on a remote SQL 2000 server. ... SQL Server and the Agent are running under a domain account instead of ... summarize the database but these jobs are failing to create. ... I tried setting the agent to use the same domain account as the proxy ...
    (microsoft.public.sqlserver)