Help! - sql server service stuck in "stopping" state

Question

Hi Guys

I have tried restarting the SQL Service (sql 2005), but for some reason the sql server service is stuck in "Stopping" state.   It has been hanging now for about 10/15 mins?

Any ideas why this is happening or how i can sort it?

Any help much appreciated.

Thanks.

Answer 1

This could happen for various reasons and one of that could be because of the user id on which the service is running. If the password is changed and that is not updated on the service account, then this can happen. It can also happen if SQL Agent is not running/not able to start.

Let me know if this is the case. It would be better if you provide the exact error that is logged in the event viewer so that we can get the actual issue in case if possible.

Regards,

---

Phani Note: Please mark the post as answered if it answers your question.

Answer 2

Thanks for your reply :) Appreciated.

Im not sure what the cause was still, but I killed the sqlserver process from the task manager window and it seemed to sort the problem.  I assume the restart request couldnt be complete because it was dependant on another process that was running.

Thanks again though.

Answer 3

Perhaps you had active connections that were trying to be rolled back.

---

Phil Brammer | http://www.ssistalk.com | Twitter: http://twitter.com/PhilBrammer

Answer 4

Hello; did this get sorted?

If not then do the following: -

Disable SQL Server.
Reboot the Server.
Inspect the Server logs as to why SQL has started and then automatically stopped.

---

Tony C