February 23, 2009 at 3:02 pm
Hi All,
I Had to rebuild my SQL server today, after installing the SQL Developer edition, I restored the master database by setting the instance to a single user mode, then restoring master.
SQL server started fine after this and master successfully restored.
At this point, I decided I wanted to restore msdb back as well so that I can have jobs etc back. After doing this by simply running a restore, this worked fine as well.
Now, SQL agent wouldnt start, I followed the steps detailed on
http://rip747.wordpress.com/2008/05/26/rebulding-msdb-in-sql-server-2005/
MSDB rebuilt from scratch, but it still wouldn't start.
Any attempt to start it gives the following errors on Application event viewer.
Event Type:Error
Event Source:Service Control Manager
Event Category:None
Event ID:7009
Date:23/02/2009
Time:21:43:09
User:N/A
Computer:ServerName
Description:
Timeout (30000 milliseconds) waiting for the SQL Server Agent (MSSQLSERVER) service to connect.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Event Type:Error
Event Source:Service Control Manager
Event Category:None
Event ID:7000
Date:23/02/2009
Time:21:43:09
User:N/A
Computer:ServerName
Description:
The SQL Server Agent (MSSQLSERVER) service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
The thing is that I have no where to look at for the specific error preventing SQL agent from start, SQL Errorlog doesn't show anything relating to SQL agent.
Any help would be really appreciated.
Thanks
February 23, 2009 at 3:27 pm
Try Event Viewer.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 23, 2009 at 3:28 pm
The Agent is disabled by default in the developer edition so go to configuration manager to make sure it is running with local systems account and turned on.
The reason it installs with network service account which may not have permissions for the MSDB rebuild.
Kind regards,
Gift Peddie
February 24, 2009 at 2:37 am
Thanks for the reply guys, but to my suprise, trying to start SQL agent from services wouldnt work, but after logging onto SQL Management Studio I was able to start up the service from SSMS and it started fine.
February 24, 2009 at 2:40 am
Also note that Any changes to Logon settings for SQL Server and Agent Should be done through Configuration Manager because behind the scenes it adds new groups to local system and assigns permissions!
Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
February 24, 2009 at 8:18 am
glad everything works but did you change anything relating to security or roles?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply