Re: Error 87 from GetProxyAccount on line 604
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 09/29/04
- Next message: Tibor Karaszi: "Re: SQLVariant and indices"
- Previous message: John McLusky: "DBCC CHECKDB results - repairable?"
- In reply to: Chris Clements: "Error 87 from GetProxyAccount on line 604"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: Error 87 from GetProxyAccount on line 604"
- Reply: anonymous_at_discussions.microsoft.com: "Re: Error 87 from GetProxyAccount on line 604"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 29 Sep 2004 19:01:29 +0200
Did you specify a proxy account? (Do this in EM, right click Agent.)
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Chris Clements" <chrisclements@msn.com> wrote in message news:3a0201c4a636$c892df90$a501280a@phx.gbl... > Error 87 from GetProxyAccount on line 604 > > > 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). >
- Next message: Tibor Karaszi: "Re: SQLVariant and indices"
- Previous message: John McLusky: "DBCC CHECKDB results - repairable?"
- In reply to: Chris Clements: "Error 87 from GetProxyAccount on line 604"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: Error 87 from GetProxyAccount on line 604"
- Reply: anonymous_at_discussions.microsoft.com: "Re: Error 87 from GetProxyAccount on line 604"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
