Hi
I'm having a problem with setting the SQL Agent Proxy Account. I get the follwoing error Message:
"Unable to set the SQL Agent Proxy Account because of the reason listed below:
'Error executing extend stored procedure: Specified user can not login'"
I have read the following article to no avail.
264155: INF: Reset Proxy and the SQLAgentCmdExec Account
283811: How to change the SQL Server or SQL Server Agent Service account without using SQL Enterprise Manager in SQL Server 2000
890775: How to configure a SQL Server Agent proxy account to enable non-system administrators to execute the xp_cmdshell extended stored procedure in SQL Server 2000
SQL: SQL 2000 SP3a on Windows 2000 Server SP4
SQLSEVER and SQLSERVERAGENT both started with a domain accont and is a local Administrator.
On a domain with group policies.
I worked fine before when the NT account was on DOMAIN1 and now the account has moved to DOMAIN2 and it is not working.
Please help.