sql server agent doesn't restart on reboot

I have a customer who is running SQL server 2000 on Windows server 2003.  When the OS is rebooted, sql server will restart automatically, but sql server agent won't.  I can go into enterprise manager and start the agent with no errors or problems.  Sql server agent is configured to restart when windows restarts. I have verfied this in both the services screen and the system registry.  Double-clicking the exe file will not restart the service, so setting up a scheduled task to restart the agent doesn't appear to be an option either.
Any suggestions on what else to check?
LVL 1
BradleyClevelandAsked:
Who is Participating?
 
BradleyClevelandConnect With a Mentor Author Commented:
The only resolution I could come up with on this was to create a scheduled task that would start the SQL server agent service and set the task 30 minutes after the reboot scheduled task. Not the resolution I was hoping for, but it does seem to work. If no one has any objections I would like to request community support to close this question.
0
 
AnujSQL Server DBACommented:
Can you check the Windows event log for any errors for more details?
0
 
AnujSQL Server DBACommented:
It seems to be a permission issue of sql server agent service.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
Shanmuga SundaramDirector of Software EngineeringCommented:
see here and let me know if it helps
0
 
Shanmuga SundaramDirector of Software EngineeringCommented:
start->run-> type services.msc

SQL Server Agent, Advanced->"Auto restart SQL Server Agent if it stops unexpectedly" was not checked.  I just checked the box
0
 
mohamedmagedCommented:
in start----> run--> Msconfig
then chose services tab and check if Sql server agent checked or not
plz replay
0
 
concretesailorsCommented:
I have seen this issue while using an NT Account, and the entity wasn't granted "Run as Service". I would recommend checking with your Active Directory Admin, or Group Policy Admin, and verify that your Agent has such permissions as "Run as Service".
0
 
BradleyClevelandAuthor Commented:
Here is the error message from the event viewer.

SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).
0
 
AnujSQL Server DBACommented:
Is your server running on virtual environment? Also can you check the service account has sufficient privilege to start the sqlserver agent service?
0
 
BradleyClevelandAuthor Commented:
I am working on a customer's server remotely for this problem. I am almost certain this is a virtual environment, but can't swear to it.  The server agent is set to logon to the local system account. This is the same setting as sql server which is starting correctly and prior to sql agent attempting to start.
0
 
AnujSQL Server DBACommented:
If this is in virtual environment, make sure the virtual server name is correctly specified in the registry settings here @
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\SQLServerAgent\ServerHost
0
 
mohamedmagedCommented:
Make sure that you don't changed  computer name
0
 
BradleyClevelandAuthor Commented:
There was nothing specified for this key. I put in the hostname of the computer that sql server is running on. Is that correct?
0
 
AnujSQL Server DBACommented:
Yes, can you try now?
0
 
BradleyClevelandAuthor Commented:
That didn't fix it. The server restarted at 4:30 this morning. Here are the two error messages from the sql server agent error log.

[000] Unable to connect to server 'waveserver2'; SQLServerAgent cannot start

[298] SQLServer Error: 1265, Cannot generate SSPI context [SQLSTATE HY000]
0
 
BradleyClevelandAuthor Commented:
Still no luck. This particular customer has their server set to automatically reboot 3 times a week. SQL server is starting up fine, but Enterprise Manager is not.
Any other ideas?
0
 
concretesailorsCommented:
And by Enterprise Manager you mean SQL Agent...?
0
 
BradleyClevelandAuthor Commented:
I've never got this problem resolved. Customer has reset options so that the server on reboots once a week. Still open for any other suggestions before I close this question
0
 
BradleyClevelandAuthor Commented:
None of the other suggestions worked.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.