Solved

sql server agent doesn't restart on reboot

Posted on 2011-09-13
19
567 Views
Last Modified: 2012-05-12
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?
0
Comment
Question by:BradleyCleveland
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 5
  • 2
  • +2
19 Comments
 
LVL 15

Expert Comment

by:Anuj
ID: 36528703
Can you check the Windows event log for any errors for more details?
0
 
LVL 15

Expert Comment

by:Anuj
ID: 36528708
It seems to be a permission issue of sql server agent service.
0
 
LVL 17

Expert Comment

by:Shanmuga Sundaram
ID: 36528718
see here and let me know if it helps
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 17

Expert Comment

by:Shanmuga Sundaram
ID: 36528725
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
 

Expert Comment

by:mohamedmaged
ID: 36530988
in start----> run--> Msconfig
then chose services tab and check if Sql server agent checked or not
plz replay
0
 
LVL 7

Expert Comment

by:concretesailors
ID: 36532729
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
 
LVL 1

Author Comment

by:BradleyCleveland
ID: 36535550
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
 
LVL 15

Expert Comment

by:Anuj
ID: 36535597
Is your server running on virtual environment? Also can you check the service account has sufficient privilege to start the sqlserver agent service?
0
 
LVL 1

Author Comment

by:BradleyCleveland
ID: 36543798
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
 
LVL 15

Expert Comment

by:Anuj
ID: 36547173
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
 

Expert Comment

by:mohamedmaged
ID: 36553213
Make sure that you don't changed  computer name
0
 
LVL 1

Author Comment

by:BradleyCleveland
ID: 36553804
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
 
LVL 15

Expert Comment

by:Anuj
ID: 36558540
Yes, can you try now?
0
 
LVL 1

Author Comment

by:BradleyCleveland
ID: 36560290
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
 
LVL 1

Author Comment

by:BradleyCleveland
ID: 36939739
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
 
LVL 7

Expert Comment

by:concretesailors
ID: 36942339
And by Enterprise Manager you mean SQL Agent...?
0
 
LVL 1

Author Comment

by:BradleyCleveland
ID: 37192277
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
 
LVL 1

Accepted Solution

by:
BradleyCleveland earned 0 total points
ID: 37796274
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
 
LVL 1

Author Closing Comment

by:BradleyCleveland
ID: 37822756
None of the other suggestions worked.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question