SQL Server Act7 Instance stuck in Starting Status

Well it’s been absolutely ages since I’ve made a post here o my blog. Quite a bit has happened in my personal and professional life since last year (my god it’s been that long!), the most important of all is that my daughter, Anoushka, was born to my wife and I and has brought so much joy to us!

This is going to be a very short post as I get back into the swing of blogging and hopefully someone might find it helpful.

I had a failed driver update for my Logitech mouse today which seemed to have killed my machine somehow. After reverting back to an earlier Restore Point (I love you Windows 8), I found that my SQL Server Act7 instance was hung on the status “Starting”, even after a reboot.

I knew I could use the cmd line command taskkill /f    to kill a process, but it needed a PID for the process. This was the bit that stumped me; how do I find the PID for a service? After a short Google session the answer came to use the sc queryex command.

So by stringing the sc queryex to a taskkill and then net start I managed to get my Act! Instance back up and running…Hurrah!

N.B remember to do this in an elevated permissions Command Prompt session!

sc queryex mssql$act7

[note down PID]

taskkill /f /pid [pid number]

net start mssql$act7