Stop SQL Service Hang from SQL Server Configuration ManagerPosted: February 24, 2020
I try to stop a SQL Server service from SQL Server Configuration Manager but it hangs there.
I found a post from the internet to use SC QueryEx and taskkill to stop the service from a commandline windon through powershell.
Here are the steps:
Find the service name from From SQL Server Configuration Manager and from a Powershell window to execute SC QueryEx command to find the PID for the service and execute another command (with admin right) taskkill /PID thePIDNumber /f
SC QueryEx MSSQL$SQL2019MAIN
—get the PID number, in my case 6372 this time
Open another powershell window as admin to execute:
taskkill /PID 6372 /f
The service will be stopped immediately.