Post reply

xp_sqlagent_proxy_account

  • March 7, 2003 at 11:58 am

    #158969

    I have server running sql2k sp3.

    When i try to excute the xp_sqlagent_proxy_account i get the following error.

    Error executing extended stored procedure: Specified user can not login

    I have the following local policies set for the SQL agent account .

    1.Act as part of the operating system

    2.Bypass traverse checking

    3.Increase quotas

    4.Log on as a batch job

    5.Log on as a service

    6.Replace a process level token.

    any help??

    Thanks,

    MK

  • March 7, 2003 at 12:25 pm

    #450589

    Execute permissions for xp_sqlagent_proxy_account default to members of the sysadmin fixed server role.

    Make sure the login you used is able to access SQL Server with 'sa' privilege.

  • March 7, 2003 at 12:27 pm

    #450590

    it has admon permissions on the box

  • March 7, 2003 at 12:30 pm

    #450591

    Try to reset the proxy account from the job system tab of SQL Server Agent Properties.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply