RE: SQL Agent won't start

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Mike Epprecht (SQL MVP) (mike_at_epprecht.net)
Date: 02/23/05 

Date: Wed, 23 Feb 2005 03:23:10 -0800

Hi

What heappens when you use Integrated Security for the conenction from SQL
Agent?

Regards
Mike

"Jonathan S" wrote:

> Our installation of SQLServer 2000 has been working fine until last week when
> SQLAgent cannot start due to a login problem with SQLServer.
>
> SQLAgent properties have not changed since the problem began, but the event
> log reports that SQLAgent cannot log on to SQLServer using the sa user. The
> sa password has been correctly entered into SQLAgent properties page (in
> Enterprise Manager) but this makes no difference, and using other SQLServer
> sysadmin accounts also do not work. Interestingly, when a sysadmin account
> other than sa is entered in the SQLAgent properties page (in Enterprise
> Manager) and the info saved, the sysadmin user has been set back to sa when
> the SQLAgent properties page is reopened.
>
> Using osql, I can log in to SQLServer using sa or any other sysadmin
> account. Profiler simply shows log in failure for sa when I attempt to start
> the SQLAgent service.
>
> Could this problem have been created by a Windows update running overnight?
> It seems that this SQLAgent log in problem started after one such update, but
> maybe I am being a little paranoid?
>
> Thanks in advance,
> --
> Jonathan S

Relevant Pages

  • RE: SQL Agent wont start
    ... Both SQLServer and SQLAgent are now run under the Local System ... Windows Admin account which was used to start these services. ... Interestingly, when a sysadmin account ...
    (microsoft.public.sqlserver.server)
  • sqlmangr.exe generated errors
    ... I looked in the log file and the error displayed ... 11:04:52.941 Exception number: c0000005 ' ... The sqlagent and sqlserver are running successfully in services but the ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Agent wont start
    ... Jonathan ... > Local Administrators group from SQL Logins then try: ... >> SQLServer and SQLAgent run, I had to change these services to start using ... >> accounts and this caused the SQLAgent log in problem. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Agent wont start
    ... SQLServer and SQLAgent run, I had to change these services to start using ... Local System Account. ... SQLAgent but I suspect some more "fiddling" was done last week with Windows ... "Griff" wrote: ...
    (microsoft.public.sqlserver.server)
  • SQL Agent wont start
    ... SQLAgent cannot start due to a login problem with SQLServer. ... SQLAgent properties have not changed since the problem began, ... sysadmin accounts also do not work. ... Could this problem have been created by a Windows update running overnight? ...
    (microsoft.public.sqlserver.server)