sql server configuration Manager

• sandra pastrana

  SSC Eights!

  Points: 979

  More actions

  April 22, 2008 at 8:30 am

  #186819

  I restarted my server in single user mode using sql server configuration manager.

  for some reason, the configuration manager does not want to open up now. It gives me the following error:

  Connection to target machine could not be made in a timely fashion.

  Now I cant access the configuration manager and the server keeps restarting in single user mode.

  Any idea how do I restart the server in normal user mode form the command prompt?

  has anyone seen the

  "Connection to target machine could not be made in a timely fashion." when trayng to open the connection manager?

  any help will be greatelly apreciated.

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  April 22, 2008 at 1:01 pm

  #805702

  you need to be very careful with single user mode - you should be able to stop and restart the service from windows services if no other way.

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/

• jamesvgeorge

  SSC-Addicted

  Points: 434

  More actions

  August 28, 2008 at 7:54 am

  #864398

  Even I had the same problem. The problem was with WMI service (dont know exactly whats the problem was). Restarted the WMI service and I was able to connect to the SSCM.