Friday, February 10, 2012

Cannot Restart SQL Server Agent

This morning when I checked to see if my weekend database jobs ran, I notice
d that the SQL Server Agent was stopped. I tried to restart it several time
s to no avail. I even stopped the SQL Server and restarted it, but the Agen
t will not start. The erro
r log has the following message in it: [241] Startup error: Unable to i
nitialize error reporting system (reason: Access is denied). The setup of t
he database has not changed (Windows 2000 Server/SQL Server 2000). The agen
t and MSSQLServer both login us
ing the same domain account which is in the administrator's group on the box
. The account role is System Administrator in SQL Server.Hi,
Try to change the start up account for SQL Agent to
"Local system account" and try starting the service.
Thanks
Hari
MCDBA
"James_Privett" <anonymous@.discussions.microsoft.com> wrote in message
news:F6066C48-9689-44DA-BA5B-6585E20B7C99@.microsoft.com...
> This morning when I checked to see if my weekend database jobs ran, I
noticed that the SQL Server Agent was stopped. I tried to restart it
several times to no avail. I even stopped the SQL Server and restarted it,
but the Agent will not start. The error log has the following message in
it: [241] Startup error: Unable to initialize error reporting system
(reason: Access is denied). The setup of the database has not changed
(Windows 2000 Server/SQL Server 2000). The agent and MSSQLServer both login
using the same domain account which is in the administrator's group on the
box. The account role is System Administrator in SQL Server.|||Thanks Hari! That worked...but I have no clue why it stopped working after
3 months with no problems...?

No comments:

Post a Comment