SQL Service Stopping

Question

SQL Service Stopping

mjbkm

Ten Centuries

Points: 1104
More actions
February 6, 2012 at 1:34 pm

#267663

Our SQL Service for our web-site just seems to be randomly stopping. What would cause something like this? Is there anything we can check??
Thank you

Viewing 4 posts - 1 through 3 (of 3 total)

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

What does the SQL errorlog say?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

johnitech.itech Hall of Fame Points: 3252 More actions · Answer 2

One common cause for the ACT7 service to stop is when Windows Automatic Updates attempts to install an update to SQL. The Act7 instance is protected - the sql update stops the service > fails to apply > doesn't restart the service. Usually this would only occur once a day (scheduled update time) but worth looking. If an update is trying to apply, you can hide it (remove it) or search our knowledgebase for steps to manually apply it.

http://community.act.com/t5/Sage-ACT/ACT-2007-MS-SQL-service-stops-randomly/td-p/102079

http://support.microsoft.com/kb/2598903

http://social.msdn.microsoft.com/Forums/en-US/sqlservicebroker/thread/b4ae878b-8e5c-4d33-a7c1-6f27e674e4c1/

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

johnitech.itech (2/6/2012)

One common cause for the ACT7 service to stop is when Windows Automatic Updates attempts to install an update to SQL. The Act7 instance is protected - the sql update stops the service > fails to apply > doesn't restart the service. Usually this would only occur once a day (scheduled update time) but worth looking. If an update is trying to apply, you can hide it (remove it) or search our knowledgebase for steps to manually apply it.

http://community.act.com/t5/Sage-ACT/ACT-2007-MS-SQL-service-stops-randomly/td-p/102079

http://support.microsoft.com/kb/2598903

http://social.msdn.microsoft.com/Forums/en-US/sqlservicebroker/thread/b4ae878b-8e5c-4d33-a7c1-6f27e674e4c1/%5B/quote%5D

None of these 3 links are useful.

The first one is about the ACT7 service - which is not the SQL Server service - although the path of Windows update is worth investigating.

The second one is about SQL Server Agent and the third one about service broker.

I said it before, and I'll say it again: posting the first 5 random Google links into a topic isn't helping anyone. Certainly not the person who posted the question, but also not you, as your reputation (what's left of it) is being damaged time after time.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP