Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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


ADDITIONAL INFORMATION:

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: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476


BUTTONS:

OK

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

share|improve this question
add comment

2 Answers 2

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
add comment

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

share|improve this answer
add comment

Your Answer

 
discard

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.