views:

260

answers:

2

I am using SQL Server 2008 express edition. I have connected before. Now I get this error message:

TITLE: Connect to Server

Cannot connect to GEF65439\SQLEXPRESS.

------------------------------ 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

------------------------------ BUTTONS:

OK

+1  A: 

Take a look at Administrative Tools\Services and restart your process SQL Server (SQLEXPRESS).

Alex
Hi Alex, thanks for your answer, but where do I find that, in SQL Server Management studio or in Configuration Manager?
Geoffrey Van Wyk
Ok, I found it in the coniguration manager. It showed the service had stopped. I started it and now it is running. Thanks very much.
Geoffrey Van Wyk
@GeoffreyBernardo: If Alex answer solved your problem, you should mark this answer as the right answer for future reference.
Gerardo Contijoch
A: 

Check if the Sql Server service is started in Administrative Tools -> Services.

What happens when you telnet to the Sql Server port, by default 1433?

telnet localhost 1433
Andomar