SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


sql server agent won't start


sql server agent won't start

Author
Message
polkadot
polkadot
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3092 Visits: 1257
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
AndrewSQLDBA
AndrewSQLDBA
SSCarpal Tunnel
SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)

Group: General Forum Members
Points: 4456 Visits: 3427
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
Shawn Melton
Shawn Melton
SSCertifiable
SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)

Group: General Forum Members
Points: 5875 Visits: 3537
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: blog.wsmelton.info
Amit Raut
Amit Raut
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1229 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.
polkadot
polkadot
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3092 Visits: 1257
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
AndrewSQLDBA
AndrewSQLDBA
SSCarpal Tunnel
SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)

Group: General Forum Members
Points: 4456 Visits: 3427
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
polkadot
polkadot
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3092 Visits: 1257
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
AndrewSQLDBA
AndrewSQLDBA
SSCarpal Tunnel
SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)

Group: General Forum Members
Points: 4456 Visits: 3427
You should have a Program group named "Configuration Tools" in each of your program groups for SQL Server.


Andrew SQLDBA
polkadot
polkadot
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3092 Visits: 1257
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
Attachments
Capture.PNG (34 views, 27.00 KB)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search