Avatar of TYB
TYB asked on

SQL Server Agent doesn't always starrt at 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 can start it manually with no problems.

I get a error in the Agents log:

1. Error,[241] Startup error: Unable to initialize error reporting system (reason: The EventLog service has not been started)
2. Information,[098] SQLServerAgent terminated (normally)

All services are to start automatically. SQL Server and the Agent runs under a domain account.
Microsoft SQL Server 2005

Avatar of undefined
Last Comment
TYB

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Askeeto

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
TYB

When using SQL Server Management Studio (or creating accounts during installation) to set the the SQL Agent Services account I understand that the accounts get all the necessary right, or?

I have not modified the account manually in any way.

I'll check the permission tomorrow and then we will see.
ASKER
TYB

I setup the dependcy between the eventlog and the SQL Server Agent and that did the trick!

Tnx a lot for the help!
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23