If you ever have trouble with a service being stuck in a 'starting' or 'stopping' state, you can run a couple of simple commands to kill the service.
1. |
Query the processTo kill the service you have to know its PID or Process ID. To find this just type the following in at a command prompt: sc queryex servicename Replace 'servicename' with the services registry name. For example: Print Spooler is spooler. C:\Users\yemen_000>sc queryex MSSQL$SQLEXPRESS SERVICE_NAME: MSSQL$SQLEXPRESS |
|
---|---|---|
2. |
Identify the PIDAfter running the query you will by presented with a list of details. You will want to locate the PID. |
|
3. |
Run the Taskkill commandNow that you have the PID, you can run the following command to kill the hung process: taskkill /f /pid [PID] This will force kill the hung service. |