Problem setting up a SQL Agent Proxy Account

From: Alex (anonymous_at_discussions.microsoft.com)
Date: 06/24/04 

Date: Thu, 24 Jun 2004 03:36:20 -0700

I have a problem setting up a SQL Agent Proxy Account so I
could make non-admin account to use xp_cmdshell.

when I tried to execute the xp
xp_sqlagent_proxy_account

I got the following: Error executing extended stored
procedure: Specified user can not login

I can confirm that the Windows account is valid, in admin
group, SQL Server start up account also in Admin group etc.

I have 5 development servers I tested on : 3 work fine and
2 failed with the above message.

I just cannot figure out why the two servers failed. Is
there anything obvious that I missed?

All servers on Sql2000 SP3, Windows 2000 SP4

Any help would be most appreciated.

Thanks

Alex

Relevant Pages

  • Re: xp_cmdshell issue, local system
    ... please make sure the service account SQL Server running under has ... this error may be because the SQL Server service ... account doesn't have the rights necessary to change security context to the ... >I want to give access to a regular user to execute xp_cmdshell. ...
    (microsoft.public.sqlserver.security)
  • Re: bcp data export from SQL Server to file
    ... the OS security context will be the SQL Server ... service account when executed by a sysadmin server role member. ... But when I execute it threw the application - nothing ...
    (microsoft.public.sqlserver.programming)
  • Re: Execute Persmission denied on object sp_OACreate
    ... > I logged in as that user, tried to execute the DTS ... which then launches the DTS package using the sp_OA* procs? ... account is used during proc execution. ... > proxy account to use in the Job Systems tab of SQL Server Agent ...
    (microsoft.public.sqlserver.security)
  • Execute Process Task not failing, but not executing the batch comm
    ... I can execute the following command from the windows "Run" prompt and it ... Might I have something set weird in SQL Server? ... server being by default configured to run as localsystem account, ...
    (microsoft.public.sqlserver.dts)
  • Re: pass stored procedure parameters in asp
    ... In Management Studio, open a new query window, logging in with the bettys ... account and try to execute the procedure. ... procedure and properties) of voidTran stored procedure and other ...
    (microsoft.public.inetserver.asp.general)