Results 1 to 1 of 1
  1. #1
    Join Date
    May 2002
    Posts
    1

    Unhappy Unanswered: xp_sqlagent_proxy_account

    When executing xp_sqlagent_proxy_account I receive "Error executing extended stored procedure: Specified user can not login" message. I am signed onto SQL Analyzer with sa. When executing xp_sqlagent_proxy_account I set the domain, id, and password equal to the domain, id, and password used for the SQL Server Agent. I did this successfully on a test server but on my development server, it fails. Can anyone help?

    I found that the NT id used to run the SQLServerAgent needed to have the NT permissions listed in MS Knowledge Base document Q264155. Once the permissions were set correctly, I was able to set the proxy account equal to the NT id used to run the SQLServerAgent.

    Case closed.
    Last edited by Daryl Williams; 05-15-02 at 10:58.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •