Unable to reset SQL agent proxy account

From: Benjamin Huang (huang_bingjun_at_hotmail.com)
Date: 04/25/03 

Date: Fri, 25 Apr 2003 06:21:32 -0700

Hi,

SQL sever 2K(SP2) on Win 2K is using the same domain
account for SQL server service account, SQL Agent account
and SQL Agent proxy account. The password for the domain
account has been changed. Resetting the SQL server sercice
and SQL agent accounts has been successful. However, while
trying to resetting the proxy account ( using stored
procedure and through Enterprise manager), I always get
the following error message:

"Unable to reset the SQL Agent proxy account because of
the reason listed below.'Error executing the extended
stored procedure: Specified user can not login."

This domain account is already being used by SQL service
account and SQL Agent account, I don't know why it says
the specified user can not login.

Thanks in advance.

Benjamin Huang

Relevant Pages

  • Re: Very Very Urgent, Please Help
    ... production servers services will always run under domian admin account. ... It sounds like you are running the SQL Agent service under the local ... system account which does not have access to the DTS packages. ...
    (microsoft.public.sqlserver.datawarehouse)
  • RE: dts package error
    ... "Donna Lambert" wrote: ... > under the context of the SQL Agent account. ... > account and try to manually kick off the package. ...
    (microsoft.public.sqlserver.dts)
  • RE: dts package error
    ... under the context of the SQL Agent account. ... account and try to manually kick off the package. ... > When it runs through the scheduler it cannot find the mdb file on the server. ...
    (microsoft.public.sqlserver.dts)
  • RE: xp_sqlagent_proxy_account
    ... If no reboot is needed (because the LOGONSERVER is set to a Domain ... Verify that the startup account for SQL Server and SQL Agent services have ...
    (microsoft.public.sqlserver.security)
  • Re: Very Very Urgent, Please Help
    ... Try logging onto the server under the domain account that the SQL Agent ... >> system account which does not have access to the DTS packages. ...
    (microsoft.public.sqlserver.datawarehouse)