Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have SQL2008 installed on my Win2008 server, and its been working fine - I have sites running using SQL databases etc..

I thought I would install SQL2008 SP1, but after install I cannot connect to SQL via Management Studio, and in configuration manager I cannot start SQL?

TITLE: Connect to Server

Cannot connect to #MYINSTANCENAME#.


A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click:



I'm not really a techie so a bit stuck?? any ideas??

share|improve this question
up vote 0 down vote accepted

Look through event viewer on the server and sql server error logs (SSMS can do this under management) to see what happened. Very important to do so.

share|improve this answer

Well after 3 restarts, I was able to start the service in configuration manager? Now its fine!?

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.