locked
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'
    GO

     

    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.

     

    Ana

     

    Thursday, September 25, 2008 9:44 PM

All replies

  • Moving to more appropriate forum.

     

    Friday, September 26, 2008 1:44 PM