Error 87 from GetProxyAccount on line 604
From: Chris Clements (chrisclements_at_msn.com)
Date: 09/29/04
- Previous message: Volt: "Changing DBO"
- Next in thread: Sue Hoegemeier: "Re: Error 87 from GetProxyAccount on line 604"
- Reply: Sue Hoegemeier: "Re: Error 87 from GetProxyAccount on line 604"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 29 Sep 2004 08:13:22 -0700
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).
- Previous message: Volt: "Changing DBO"
- Next in thread: Sue Hoegemeier: "Re: Error 87 from GetProxyAccount on line 604"
- Reply: Sue Hoegemeier: "Re: Error 87 from GetProxyAccount on line 604"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
