Vidhya Sagar – Blog One Stop for SQL Server related Queries

24Jun/09

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.3_1094]
Rating: 3.0/5 (2 votes cast)
VN:F [1.9.3_1094]
Rating: 0 (from 0 votes)
Connection to the target machine could not be made in a timely fashion – SSCM, 3.0 out of 5 based on 2 ratings
Comments (3) Trackbacks (0)
  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?


Leave a comment


No trackbacks yet.