Solved

Management Studio : A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible.

Posted on 2011-03-23
2
1,024 Views
Last Modified: 2012-06-21
I've just installed SQL Server 2008 R2 Express on a Windows 7 laptop. When I start up the Management Studio and try to connect with Windows authentication, it gives the error -

TITLE: Connect to Server
------------------------------

Cannot connect to 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: 53)

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



The SQL Server (SQL EXPRESS) and SQL Server Browser services are running and the Agent service is stopped.

Once again, I'd appreciate any help.
0
Comment
Question by:Ast35
2 Comments
 
LVL 14

Accepted Solution

by:
Daniel_PL earned 500 total points
ID: 35199486
Are you connecting to MachineName\SQLEXPRESS?
0
 

Author Comment

by:Ast35
ID: 35199522
No, I wasn't!

I am now. Thanks!
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now