Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sql server agent won't start Expand / Collapse
Author
Message
Posted Tuesday, October 29, 2013 4:56 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, July 20, 2014 8:23 AM
Points: 272, Visits: 734
SQL Server 2012
SQL ServerAgent is currently Stopped. I want it to be running, so I right click and select start and get the dialogue box error:
"The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details."

I go to Windows Event Logs and find this:

"The log scan number (18:78:1) passed to log scan in database 'model' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup."

I googled the error and found advice to run DBCC CHECKDB, which I did and got

"...CHECKDB found 0 allocation errors and 0 consistency errors in database 'model'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.".
There were no errors.

Can someone please help me further troubleshoot the issue? Goal is to start SQL Server Agent. I'm logged in with the same login used to install SQL Server, also the default logon for SQL Server Agent.
Post #1509609
Posted Tuesday, October 29, 2013 5:08 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, July 17, 2014 3:19 PM
Points: 975, Visits: 3,342
What is the service account that the Agent is using? Is that account valid? After I check that, and verified that I can login to Windows with that account, I would restore the database from a backup. Use the backup that was good the last time the service started. Verifying the login is much easier than the restore. I would do that step as a just in case. But the error actually tells you what is needed, restore the database.

Andrew SQLDBA

Post #1509611
Posted Tuesday, October 29, 2013 6:54 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 8:27 AM
Points: 836, Visits: 2,286
The error provided is not associated with SQL Server Agent not starting, you normally see it when trying to start the SQL Server Service.

You will likely find that the SQL Server service for this instance is probably not running. Which that is going to prevent SQL Server Agent from starting as it has a dependency.


Shawn Melton
PS C:\>(Find-Me).TwitterURL
@wsmelton
PS C:\>(Find-Me).BlogURL
meltondba.wordpress.com
Post #1509626
Posted Friday, November 1, 2013 5:25 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 6:12 PM
Points: 827, Visits: 342
Shawn Melton (10/29/2013)
The error provided is not associated with SQL Server Agent not starting, you normally see it when trying to start the SQL Server Service.

You will likely find that the SQL Server service for this instance is probably not running. Which that is going to prevent SQL Server Agent from starting as it has a dependency.


That's exactly had happened with my server. Once I restarted SQL Server Services through services.msc, Agent also worked fine.
Post #1510829
Posted Wednesday, November 6, 2013 10:36 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, July 20, 2014 8:23 AM
Points: 272, Visits: 734
OK, you're right about SQL Server not running. It's also stopped and I can't get it to start, either.
I click start, a progress bar shows a lot of progress starting the service and then bam, error message:
"The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details."

Post #1511953
Posted Wednesday, November 6, 2013 11:30 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, July 17, 2014 3:19 PM
Points: 975, Visits: 3,342
Ok, so what does the event log state?

Open the SQL logs via text editor and see if there is something in there.

Andrew SQLDBA
Post #1511967
Posted Thursday, November 14, 2013 11:39 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, July 20, 2014 8:23 AM
Points: 272, Visits: 734
OK, well, one thing I overlooked is that I created my SQL Server Agent job in SQL Server 2012, but the above problems are presenting in the Configuration Manager next to SQL Server 2008 services. I wasn't paying attention to that important detail because I wasn't really attuned to the fact I'd installed both 8 and 12 some time ago....
When I do a SELECT @@version in SSMC I see I've been working in 2012 (daily)...yet the only services listed in Config Manager are for 2008.
How to get config manager to show the 2012 services? (I'm in Windows 8)
Post #1514416
Posted Thursday, November 14, 2013 12:00 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, July 17, 2014 3:19 PM
Points: 975, Visits: 3,342
You should have a Program group named "Configuration Tools" in each of your program groups for SQL Server.


Andrew SQLDBA
Post #1514427
Posted Sunday, November 17, 2013 5:16 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, July 20, 2014 8:23 AM
Points: 272, Visits: 734
Hi, I've attached screen capture.
The only place there are two groupings, one for 2008 and one for 2012, is under Network Configuration, no where else.
Will someone look at the screen capture? I've no idea why non of the services for 2012 are listed.


  Post Attachments 
Capture.PNG (13 views, 27.20 KB)
Post #1515040
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse