Re: Error 87 from GetProxyAccount on line 604

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 09/29/04 

Date: Wed, 29 Sep 2004 10:46:45 -0600

Make sure the 'Only users with sysadmin privileges ...' box is
unchecked from Enterprise Manager
Go to Management node to SQL ServerAgent. Right click on SQL Server
Agent and select Properties and select the Job System tab.

-Sue

On Wed, 29 Sep 2004 08:13:22 -0700, "Chris Clements"
<chrisclements@msn.com> wrote:

>I am trying to set up a regular SQL login which is NOT a
>sysadmin with the ability to run xp_cmdshell. It's not
>the best idea, but I have no choice. I granted it
>execute permissions on the proc and used
>xp_sqlagent_proxy_account to point to a login which is a
>local admin on the server. Whenever I try to execute
>xp_cmdshell under that account, I get the error :
>
>Msg 50001, Level 1, State 50001
>xpsql.cpp: Error 87 from GetProxyAccount on line 604
>
>A search of KB and a few of these newsgroups turned up
>nothing. The version number of SQL Server is 08.00.0818
>(sp3 + security update).

Relevant Pages

  • invalid value specified for STOPAT parameter
    ... I too had problems when trying to perform a Point in Time restore ... Enterprise Manager, I receive a error message "Invalid value specified ... "YDM" by SQL Server where as the value supplied by the SQL Server ... Select "British English", then hit OK. ...
    (microsoft.public.sqlserver.server)
  • Re: Tools with/for Express
    ... Enterprise Manager does not work with SQL Server 2005. ... Analyzer is pretty dumb and just passes on what you type, ... But Enterprise Manager tries to write it's own code and it doesn't use SQL ... I then attempted to use Query Analyzer. ...
    (microsoft.public.sqlserver.tools)
  • Re: Replication problems
    ... machine than SQL Server as you must reference a share on the machine and not ... You can't create a publication due to the 1038 error. ... > not yet have any Publications in my Enterprise Manager. ... > start the SQL Server Agent service manually". ...
    (microsoft.public.sqlserver.ce)
  • Re: MSSQL$MSFW :: How to connect to it with SQL Server Enterprise Manager?
    ... > The question is - can I connect to this instance with either SQL Server ... The firewall MSDE is a SQL 2000 instance. ... W3WALL\MSFW as the SQL Server in Enterprise Manager. ... Install the client tools on the firewall, login as ...
    (microsoft.public.isaserver)
  • Re: login security question
    ... > I have an application which connects to the SQL server. ... Use Enterprise Manager to access the database / roles. ... Give the Application Role the appropriate permissions. ... what the stored proc is called) using the secret password for the App Role ...
    (microsoft.public.sqlserver.server)