sql server agent won't start

  • 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.

    --Quote me

  • 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

  • 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
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • 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.

  • 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."

    --Quote me

  • 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

  • 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)

    --Quote me

  • You should have a Program group named "Configuration Tools" in each of your program groups for SQL Server.

    Andrew SQLDBA

  • 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.

    --Quote me

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply