Re: Cannot Restart SQL Server Agent
From: Hari (hari_prasad_k_at_hotmail.com)
Date: 03/09/04
- Next message: Hari: "Re: Rebuild of SQL Server"
- Previous message: Greg H: "Rebuild of SQL Server"
- In reply to: James_Privett: "Cannot Restart SQL Server Agent"
- Next in thread: James_Privett: "Re: Cannot Restart SQL Server Agent"
- Reply: James_Privett: "Re: Cannot Restart SQL Server Agent"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 9 Mar 2004 10:49:45 +0530
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.
- Next message: Hari: "Re: Rebuild of SQL Server"
- Previous message: Greg H: "Rebuild of SQL Server"
- In reply to: James_Privett: "Cannot Restart SQL Server Agent"
- Next in thread: James_Privett: "Re: Cannot Restart SQL Server Agent"
- Reply: James_Privett: "Re: Cannot Restart SQL Server Agent"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
