SQL Server 2000 Agent Proxy Account Error 'The system cannot find the path specified.' RRS feed

  • Question


    I get this error when I try to Reset proxy account on the Porperties\Job System tab in the Enterprise Manager.


    When I try to set/edit/delete from Query Analizer using N'SET'


    EXECUTE xp_sqlagent_proxy_account N'set'
    , N'<DOMAIN>'
    , N'<myUSER>'
    , N'<myPASSWORD>'


    I get the following error:


    Error executing extended stored procedure: Specified user can not login


    The thing is that the first time I set the proxy account, it worked out, because when I execute the following statement:


    EXECUTE xp_sqlagent_proxy_account N'GET'


    I get as a result my domain and user.


    It seems that the proxy was set correctly, but now I can't change de domain account.


    Please advise!! I have several processes using this proxy and I need to change the account. Any help will be greatly appreciated.




    Thursday, September 25, 2008 9:44 PM

All replies

  • Moving to more appropriate forum.


    Friday, September 26, 2008 1:44 PM