We have a Windows Server 2003 SP1, SQL Server 2005 SP1. When the
machine is rebooted, the SQL Server agent is not automatically started.
It is set to start automatically in the Windows Services dialog. I
see a safe shutdown prior to the reboot, but no messages like it's even
trying to start up. I can start it manually with no problems.
Any ideas what to check or where to go from here?Hi
Have you checked the sql server agent log file in Management studio? Also
check what SQL Server Configuration Manager has for the service and check
that error reporting is selected on the advanced tab.
John
"PSPDBA" wrote:
> We have a Windows Server 2003 SP1, SQL Server 2005 SP1. When the
> machine is rebooted, the SQL Server agent is not automatically started.
> It is set to start automatically in the Windows Services dialog. I
> see a safe shutdown prior to the reboot, but no messages like it's even
> trying to start up. I can start it manually with no problems.
> Any ideas what to check or where to go from here?
>|||Agent log shows:
Message
[241] Startup error: Unable to initialize error reporting system
(reason: The EventLog service has not been started)
However, The EventLog service is also set to automatic.
John Bell wrote:
> Hi
> Have you checked the sql server agent log file in Management studio? Also
> check what SQL Server Configuration Manager has for the service and check
> that error reporting is selected on the advanced tab.
> John
> "PSPDBA" wrote:
> > We have a Windows Server 2003 SP1, SQL Server 2005 SP1. When the
> > machine is rebooted, the SQL Server agent is not automatically started.
> > It is set to start automatically in the Windows Services dialog. I
> > see a safe shutdown prior to the reboot, but no messages like it's even
> > trying to start up. I can start it manually with no problems.
> >
> > Any ideas what to check or where to go from here?
> >
> >|||Hi
I assume that the EventLog has started correctly?
Making SQL Agent dependent on the EventLog service would ensure that it has
started before SQL Agent starts.
If the service is running as LOCALSYSTEM you could change it to an domain
account.
John
"PSPDBA" wrote:
> Agent log shows:
> Message
> [241] Startup error: Unable to initialize error reporting system
> (reason: The EventLog service has not been started)
> However, The EventLog service is also set to automatic.
> John Bell wrote:
> > Hi
> >
> > Have you checked the sql server agent log file in Management studio? Also
> > check what SQL Server Configuration Manager has for the service and check
> > that error reporting is selected on the advanced tab.
> >
> > John
> >
> > "PSPDBA" wrote:
> >
> > > We have a Windows Server 2003 SP1, SQL Server 2005 SP1. When the
> > > machine is rebooted, the SQL Server agent is not automatically started.
> > > It is set to start automatically in the Windows Services dialog. I
> > > see a safe shutdown prior to the reboot, but no messages like it's even
> > > trying to start up. I can start it manually with no problems.
> > >
> > > Any ideas what to check or where to go from here?
> > >
> > >
>|||Yep, it sure has. I was thinking of doing both of those things. I'll
give it a try.
John Bell wrote:
> Hi
> I assume that the EventLog has started correctly?
> Making SQL Agent dependent on the EventLog service would ensure that it has
> started before SQL Agent starts.
> If the service is running as LOCALSYSTEM you could change it to an domain
> account.
> John
> "PSPDBA" wrote:
> > Agent log shows:
> >
> > Message
> > [241] Startup error: Unable to initialize error reporting system
> > (reason: The EventLog service has not been started)
> >
> > However, The EventLog service is also set to automatic.
> >
> > John Bell wrote:
> > > Hi
> > >
> > > Have you checked the sql server agent log file in Management studio? Also
> > > check what SQL Server Configuration Manager has for the service and check
> > > that error reporting is selected on the advanced tab.
> > >
> > > John
> > >
> > > "PSPDBA" wrote:
> > >
> > > > We have a Windows Server 2003 SP1, SQL Server 2005 SP1. When the
> > > > machine is rebooted, the SQL Server agent is not automatically started.
> > > > It is set to start automatically in the Windows Services dialog. I
> > > > see a safe shutdown prior to the reboot, but no messages like it's even
> > > > trying to start up. I can start it manually with no problems.
> > > >
> > > > Any ideas what to check or where to go from here?
> > > >
> > > >
> >
> >|||Hi
You didn't say if the service was running under local system or not'
Looking at other posts http://tinyurl.com/rvql2 the service account seems to
be a prime reason for this failure. To change this manually check out
http://support.microsoft.com/?id=283811
John
"PSPDBA" wrote:
> Yep, it sure has. I was thinking of doing both of those things. I'll
> give it a try.
>
> John Bell wrote:
> > Hi
> >
> > I assume that the EventLog has started correctly?
> >
> > Making SQL Agent dependent on the EventLog service would ensure that it has
> > started before SQL Agent starts.
> >
> > If the service is running as LOCALSYSTEM you could change it to an domain
> > account.
> >
> > John
> >
> > "PSPDBA" wrote:
> >
> > > Agent log shows:
> > >
> > > Message
> > > [241] Startup error: Unable to initialize error reporting system
> > > (reason: The EventLog service has not been started)
> > >
> > > However, The EventLog service is also set to automatic.
> > >
> > > John Bell wrote:
> > > > Hi
> > > >
> > > > Have you checked the sql server agent log file in Management studio? Also
> > > > check what SQL Server Configuration Manager has for the service and check
> > > > that error reporting is selected on the advanced tab.
> > > >
> > > > John
> > > >
> > > > "PSPDBA" wrote:
> > > >
> > > > > We have a Windows Server 2003 SP1, SQL Server 2005 SP1. When the
> > > > > machine is rebooted, the SQL Server agent is not automatically started.
> > > > > It is set to start automatically in the Windows Services dialog. I
> > > > > see a safe shutdown prior to the reboot, but no messages like it's even
> > > > > trying to start up. I can start it manually with no problems.
> > > > >
> > > > > Any ideas what to check or where to go from here?
> > > > >
> > > > >
> > >
> > >
>
Showing posts with label reboot. Show all posts
Showing posts with label reboot. Show all posts
Thursday, February 9, 2012
2005 Agent doesn't start automatically on reboot
We have a Windows Server 2003 SP1, SQL Server 2005 SP1. When the
machine is rebooted, the SQL Server agent is not automatically started.
It is set to start automatically in the Windows Services dialog. I
see a safe shutdown prior to the reboot, but no messages like it's even
trying to start up. I can start it manually with no problems.
Any ideas what to check or where to go from here?Hi
Have you checked the sql server agent log file in Management studio? Also
check what SQL Server Configuration Manager has for the service and check
that error reporting is selected on the advanced tab.
John
"PSPDBA" wrote:
> We have a Windows Server 2003 SP1, SQL Server 2005 SP1. When the
> machine is rebooted, the SQL Server agent is not automatically started.
> It is set to start automatically in the Windows Services dialog. I
> see a safe shutdown prior to the reboot, but no messages like it's even
> trying to start up. I can start it manually with no problems.
> Any ideas what to check or where to go from here?
>|||Agent log shows:
Message
[241] Startup error: Unable to initialize error reporting system
(reason: The EventLog service has not been started)
However, The EventLog service is also set to automatic.
John Bell wrote:[vbcol=seagreen]
> Hi
> Have you checked the sql server agent log file in Management studio? Also
> check what SQL Server Configuration Manager has for the service and check
> that error reporting is selected on the advanced tab.
> John
> "PSPDBA" wrote:
>|||Hi
I assume that the EventLog has started correctly?
Making SQL Agent dependent on the EventLog service would ensure that it has
started before SQL Agent starts.
If the service is running as LOCALSYSTEM you could change it to an domain
account.
John
"PSPDBA" wrote:
> Agent log shows:
> Message
> [241] Startup error: Unable to initialize error reporting system
> (reason: The EventLog service has not been started)
> However, The EventLog service is also set to automatic.
> John Bell wrote:
>|||Yep, it sure has. I was thinking of doing both of those things. I'll
give it a try.
John Bell wrote:[vbcol=seagreen]
> Hi
> I assume that the EventLog has started correctly?
> Making SQL Agent dependent on the EventLog service would ensure that it ha
s
> started before SQL Agent starts.
> If the service is running as LOCALSYSTEM you could change it to an domain
> account.
> John
> "PSPDBA" wrote:
>|||Hi
You didn't say if the service was running under local system or not'
Looking at other posts http://tinyurl.com/rvql2 the service account seems to
be a prime reason for this failure. To change this manually check out
http://support.microsoft.com/?id=283811
John
"PSPDBA" wrote:
> Yep, it sure has. I was thinking of doing both of those things. I'll
> give it a try.
>
> John Bell wrote:
>
machine is rebooted, the SQL Server agent is not automatically started.
It is set to start automatically in the Windows Services dialog. I
see a safe shutdown prior to the reboot, but no messages like it's even
trying to start up. I can start it manually with no problems.
Any ideas what to check or where to go from here?Hi
Have you checked the sql server agent log file in Management studio? Also
check what SQL Server Configuration Manager has for the service and check
that error reporting is selected on the advanced tab.
John
"PSPDBA" wrote:
> We have a Windows Server 2003 SP1, SQL Server 2005 SP1. When the
> machine is rebooted, the SQL Server agent is not automatically started.
> It is set to start automatically in the Windows Services dialog. I
> see a safe shutdown prior to the reboot, but no messages like it's even
> trying to start up. I can start it manually with no problems.
> Any ideas what to check or where to go from here?
>|||Agent log shows:
Message
[241] Startup error: Unable to initialize error reporting system
(reason: The EventLog service has not been started)
However, The EventLog service is also set to automatic.
John Bell wrote:[vbcol=seagreen]
> Hi
> Have you checked the sql server agent log file in Management studio? Also
> check what SQL Server Configuration Manager has for the service and check
> that error reporting is selected on the advanced tab.
> John
> "PSPDBA" wrote:
>|||Hi
I assume that the EventLog has started correctly?
Making SQL Agent dependent on the EventLog service would ensure that it has
started before SQL Agent starts.
If the service is running as LOCALSYSTEM you could change it to an domain
account.
John
"PSPDBA" wrote:
> Agent log shows:
> Message
> [241] Startup error: Unable to initialize error reporting system
> (reason: The EventLog service has not been started)
> However, The EventLog service is also set to automatic.
> John Bell wrote:
>|||Yep, it sure has. I was thinking of doing both of those things. I'll
give it a try.
John Bell wrote:[vbcol=seagreen]
> Hi
> I assume that the EventLog has started correctly?
> Making SQL Agent dependent on the EventLog service would ensure that it ha
s
> started before SQL Agent starts.
> If the service is running as LOCALSYSTEM you could change it to an domain
> account.
> John
> "PSPDBA" wrote:
>|||Hi
You didn't say if the service was running under local system or not'
Looking at other posts http://tinyurl.com/rvql2 the service account seems to
be a prime reason for this failure. To change this manually check out
http://support.microsoft.com/?id=283811
John
"PSPDBA" wrote:
> Yep, it sure has. I was thinking of doing both of those things. I'll
> give it a try.
>
> John Bell wrote:
>
2005 Agent does not start on Reboot
I have a Windows 2003 server that is running SQL Server 2005 SP1. When the
server is rebooted, the SQL Server agent does not start. The service is set
to start automatically and is running with a domain account that has local
administrative privileges.
The Agent log has the following entries immediately after the reboot:
Date 6/3/2006 10:59:18 AM
Log SQL Agent (Archive #1 - 6/3/2006 10:59:00 AM)
Message
[098] SQLServerAgent terminated (normally)
---
Date 6/3/2006 10:58:36 AM
Log SQL Agent (Archive #1 - 6/3/2006 10:59:00 AM)
Message
[241] Startup error: Unable to initialize error reporting system (reason
:
The EventLog service has not been started)
I think I have done my homework researching this issue but have not found
anything that has fixed the problem.
Any help would be appreciated.
Thanks!
ChrisDid you check whether the Event Log service is disabled or is a manual
startup service in the services applet (administrative tools). If it is not
set to auto-start, make it auto start, reboot machine and see what happens.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Cgal" <cgallelli@.newsgroups.nospam> wrote in message
news:eOgvVhKiGHA.3296@.TK2MSFTNGP05.phx.gbl...
I have a Windows 2003 server that is running SQL Server 2005 SP1. When the
server is rebooted, the SQL Server agent does not start. The service is set
to start automatically and is running with a domain account that has local
administrative privileges.
The Agent log has the following entries immediately after the reboot:
Date 6/3/2006 10:59:18 AM
Log SQL Agent (Archive #1 - 6/3/2006 10:59:00 AM)
Message
[098] SQLServerAgent terminated (normally)
---
Date 6/3/2006 10:58:36 AM
Log SQL Agent (Archive #1 - 6/3/2006 10:59:00 AM)
Message
[241] Startup error: Unable to initialize error reporting system (reason
:
The EventLog service has not been started)
I think I have done my homework researching this issue but have not found
anything that has fixed the problem.
Any help would be appreciated.
Thanks!
Chris
server is rebooted, the SQL Server agent does not start. The service is set
to start automatically and is running with a domain account that has local
administrative privileges.
The Agent log has the following entries immediately after the reboot:
Date 6/3/2006 10:59:18 AM
Log SQL Agent (Archive #1 - 6/3/2006 10:59:00 AM)
Message
[098] SQLServerAgent terminated (normally)
---
Date 6/3/2006 10:58:36 AM
Log SQL Agent (Archive #1 - 6/3/2006 10:59:00 AM)
Message
[241] Startup error: Unable to initialize error reporting system (reason
:
The EventLog service has not been started)
I think I have done my homework researching this issue but have not found
anything that has fixed the problem.
Any help would be appreciated.
Thanks!
ChrisDid you check whether the Event Log service is disabled or is a manual
startup service in the services applet (administrative tools). If it is not
set to auto-start, make it auto start, reboot machine and see what happens.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Cgal" <cgallelli@.newsgroups.nospam> wrote in message
news:eOgvVhKiGHA.3296@.TK2MSFTNGP05.phx.gbl...
I have a Windows 2003 server that is running SQL Server 2005 SP1. When the
server is rebooted, the SQL Server agent does not start. The service is set
to start automatically and is running with a domain account that has local
administrative privileges.
The Agent log has the following entries immediately after the reboot:
Date 6/3/2006 10:59:18 AM
Log SQL Agent (Archive #1 - 6/3/2006 10:59:00 AM)
Message
[098] SQLServerAgent terminated (normally)
---
Date 6/3/2006 10:58:36 AM
Log SQL Agent (Archive #1 - 6/3/2006 10:59:00 AM)
Message
[241] Startup error: Unable to initialize error reporting system (reason
:
The EventLog service has not been started)
I think I have done my homework researching this issue but have not found
anything that has fixed the problem.
Any help would be appreciated.
Thanks!
Chris
2005 Agent does not start on Reboot
I have a Windows 2003 server that is running SQL Server 2005 SP1. When the
server is rebooted, the SQL Server agent does not start. The service is set
to start automatically and is running with a domain account that has local
administrative privileges.
The Agent log has the following entries immediately after the reboot:
Date 6/3/2006 10:59:18 AM
Log SQL Agent (Archive #1 - 6/3/2006 10:59:00 AM)
Message
[098] SQLServerAgent terminated (normally)
---
Date 6/3/2006 10:58:36 AM
Log SQL Agent (Archive #1 - 6/3/2006 10:59:00 AM)
Message
[241] Startup error: Unable to initialize error reporting system (reason:
The EventLog service has not been started)
I think I have done my homework researching this issue but have not found
anything that has fixed the problem.
Any help would be appreciated.
Thanks!
ChrisDid you check whether the Event Log service is disabled or is a manual
startup service in the services applet (administrative tools). If it is not
set to auto-start, make it auto start, reboot machine and see what happens.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Cgal" <cgallelli@.newsgroups.nospam> wrote in message
news:eOgvVhKiGHA.3296@.TK2MSFTNGP05.phx.gbl...
I have a Windows 2003 server that is running SQL Server 2005 SP1. When the
server is rebooted, the SQL Server agent does not start. The service is set
to start automatically and is running with a domain account that has local
administrative privileges.
The Agent log has the following entries immediately after the reboot:
Date 6/3/2006 10:59:18 AM
Log SQL Agent (Archive #1 - 6/3/2006 10:59:00 AM)
Message
[098] SQLServerAgent terminated (normally)
---
Date 6/3/2006 10:58:36 AM
Log SQL Agent (Archive #1 - 6/3/2006 10:59:00 AM)
Message
[241] Startup error: Unable to initialize error reporting system (reason:
The EventLog service has not been started)
I think I have done my homework researching this issue but have not found
anything that has fixed the problem.
Any help would be appreciated.
Thanks!
Chris
server is rebooted, the SQL Server agent does not start. The service is set
to start automatically and is running with a domain account that has local
administrative privileges.
The Agent log has the following entries immediately after the reboot:
Date 6/3/2006 10:59:18 AM
Log SQL Agent (Archive #1 - 6/3/2006 10:59:00 AM)
Message
[098] SQLServerAgent terminated (normally)
---
Date 6/3/2006 10:58:36 AM
Log SQL Agent (Archive #1 - 6/3/2006 10:59:00 AM)
Message
[241] Startup error: Unable to initialize error reporting system (reason:
The EventLog service has not been started)
I think I have done my homework researching this issue but have not found
anything that has fixed the problem.
Any help would be appreciated.
Thanks!
ChrisDid you check whether the Event Log service is disabled or is a manual
startup service in the services applet (administrative tools). If it is not
set to auto-start, make it auto start, reboot machine and see what happens.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Cgal" <cgallelli@.newsgroups.nospam> wrote in message
news:eOgvVhKiGHA.3296@.TK2MSFTNGP05.phx.gbl...
I have a Windows 2003 server that is running SQL Server 2005 SP1. When the
server is rebooted, the SQL Server agent does not start. The service is set
to start automatically and is running with a domain account that has local
administrative privileges.
The Agent log has the following entries immediately after the reboot:
Date 6/3/2006 10:59:18 AM
Log SQL Agent (Archive #1 - 6/3/2006 10:59:00 AM)
Message
[098] SQLServerAgent terminated (normally)
---
Date 6/3/2006 10:58:36 AM
Log SQL Agent (Archive #1 - 6/3/2006 10:59:00 AM)
Message
[241] Startup error: Unable to initialize error reporting system (reason:
The EventLog service has not been started)
I think I have done my homework researching this issue but have not found
anything that has fixed the problem.
Any help would be appreciated.
Thanks!
Chris
Subscribe to:
Posts (Atom)