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
    contactjimmys, Oct 25, 2006
    #2

  2. satya Moderator

    satya, Oct 25, 2006
    #2

  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
    contactjimmys, Oct 26, 2006
    #2

  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.
    satya, Oct 26, 2006
    #2

Share This Page