we have seen this issue for the SQL servers running on VM, whenever forced reboot occurred / unexpected shutdown happens.
A reboot can fix this issue but without a reboot, we can fix it.
Fix is :
- From the command prompt Run SC QueryEx MSSQLServer
- Get PID for the output
- run taskkill /PID PID# /f , to kill Hung process.