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



3 thoughts on “SQL Server Act7 Instance stuck in Starting Status

  1. Vivek, congrats to you and your wife on the birth of your daughter! Glad to see you back in the blogosphere 🙂

  2. Thanks! It’s hard finding the time to write each blog article with 2 kids and 2 dogs! Hahaha! Hopefully see you at conference in November 2014?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s