Tuesday, March 27, 2012

Error 87 - more info

Does any one know what this is about
i think its something to do with running the xp_cmdshell
**as a non sys admin user
[Microsoft][ODBC SQL Server Driver][SQL Server]xpsql.cpp:
Error 87 from GetProxyAccount on line 604
some saidto run this
exec master..xp_sqlagent_proxy_account N'SET',
N'DomainName',
N'UserName',
N'Password'
but didn't make any difference .. HELP
any ideas.
thanks
mic
.Hiave you tried the suggestion in response to your previous thread? Check
to ensure the 'Only users with sysadmin privileges ...' box is unchecked
from Enterprise Manager (Management\SQL Server Agent\Properties\Job System).
Hope this helps.
Dan Guzman
SQL Server MVP
"mike" <anonymous@.discussions.microsoft.com> wrote in message
news:028c01c3bd2a$e0792e20$a401280a@.phx.gbl...
quote:

> Does any one know what this is about
> i think its something to do with running the xp_cmdshell
> **as a non sys admin user
> [Microsoft][ODBC SQL Server Driver][SQL Server]xpsql.cpp:
> Error 87 from GetProxyAccount on line 604
> some saidto run this
> exec master..xp_sqlagent_proxy_account N'SET',
> N'DomainName',
> N'UserName',
> N'Password'
> but didn't make any difference .. HELP
> any ideas.
>
> thanks
> mic
>
> .
>

No comments:

Post a Comment