If you have a service that is stuck on the 'Stopping' state and can't be restarted, stopped etc, normally restarting the machine will resolve the issue but if it's a production machine then you obviously want to avoid this.
To restart a service stuck in the 'Stopping' state, open a command prompt > taskkill /PID XXX /F (replacing XX with the PID of the offending service. Locate the PID in taskmgr > Services > PID).
It could be also necessary:
ReplyDeletetaskkill /IM sqlservr.exe /F