Problem:
In our cluster environment I was testing SQL failover, when I failed over to passive node I can no longer launch SQL Server configuration manager (SSCM). When I tried to open SSCM, MMC has waited for 30 seconds and gave me the error below.
“Connection to target machine could not be made in a timely fashion”
Resolution:
Upon researching on this I found that WMI Service (Windows Management Instrumentation Service) is in hanged state. After restarting the service on passive node, it worked for me. Steps to restart the service is below.
- Go to Run –> type services.msc and press enter
- Right click on the service “Windows Management Instrumentation” and click on restart option in the menu
- Now launch SQL Server configuration manager, it should work fine now.
The best information i have found exactly here. Keep going Thank you
I tried this but it didn’t work. I’m having the same error message when I try to restart the WMI service.
Any help?
Thanks in advance.
Do you have admin rights in the server?
Is this clustered environment?
Its not worked for me…. m using SQL server 2008 in Windows server 2008 R2.
What is the error message you are getting Suresh?
this didnt work for me