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 13:16:30 -0600

Yeah...if you have the KB article, it will be exactly as it says -
just related to the permissions of the service account.

-Sue

On Wed, 29 Sep 2004 10:15:40 -0700, "Chris Clements"
<chrisclements@msn.com> wrote:

>Once I did that, the error message changed to :
>
>xpsql.c: Error 1314 from CreateProcessAsUser on line 492
>
>I found that one in the KB though and am working out the
>details now. Thanks for your help.
>
>>-----Original Message-----
>>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

  • Re: Unable to Backup on Network
    ... If you changed the service account through control panel, ... use Enterprise Manager and set the service accounts to local ... But it will clear up permission, rights issues that you have with the ... >> necessary permissions and rights for the service account. ...
    (microsoft.public.sqlserver.security)
  • Re: login security question
    ... Say the password for the Application role is found, can a user access the database through the Query Analyser or Enterprise Manager using the application rolde/password. ... > validated and converted to an owner profile, ... > 2) 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)
  • Re: Users not visible in databases user folder
    ... Are you member of sysadmin server role? ... > I use enterprise manager for my SQL-Server databases. ... > I can no longer see my users listed in any of my databases' user folders. ... > permissions - everything looks in order. ...
    (microsoft.public.sqlserver.security)
  • Re: Hiding database objects
    ... I'm afraid that Enterprise Manager and Query Analyzer are not designed to ... can't deny any permissions to members of the sysadmin role, ...
    (microsoft.public.sqlserver.security)
  • Re: Help changing SQL startup account - registry permissions problem?
    ... setting all the required file and registry permissions. ... Directory from within Enterprise Manager I get an error "Error 14303: ...
    (microsoft.public.sqlserver.setup)