Connection to the target machine could not be made in a timely fashion – SSCM

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

sscm-error

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.
VN:F [1.9.17_1161]
Rating: 3.7/5 (3 votes cast)
VN:F [1.9.17_1161]
Rating: +1 (from 1 vote)
Connection to the target machine could not be made in a timely fashion – SSCM, 3.7 out of 5 based on 3 ratings
  1. The best information i have found exactly here. Keep going Thank you

  2. 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.

  3. Do you have admin rights in the server?
    Is this clustered environment?

  4. Its not worked for me…. m using SQL server 2008 in Windows server 2008 R2.

  5. What is the error message you are getting Suresh?

  6. this didnt work for me

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>