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.