Re: Error 87 from GetProxyAccount on line 604

From: Chris Clements (chrisclements_at_msn.com)
Date: 09/29/04 

Date: Wed, 29 Sep 2004 10:15:40 -0700

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).
>
>.
>