SQL Server Performance

xpsql.cpp: Err 87 from GetProxyAccount on line 6

Discussion in 'General DBA Questions' started by contactjimmys, Oct 25, 2006.

  1. contactjimmys New Member

    When job runs it logged the error as shown below
    xpsql.cpp: Error 87 from GetProxyAccount on line 604'

    Recyled the sql agent and it fixed the issue .

    What is the reason for the same .Any help >?????


    Thanks In advance

    DBA
    SHAMS
  2. satya Moderator

  3. contactjimmys New Member

    The link specifies how to configue proxy account. My doubt is why the error is logging ( reason) and when the agent service is recycled it is working fine.


    Thanks

    DBA
    SHAMS
  4. satya Moderator

    Because of the lack of privileges in running with the Proxy account.
    Have you locked down XP[-]CMDSHELL for non sysadmin users?
    Also make sure the SQLAgent has got relevant privileges when this job is running.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page