Solved

Cannot open SQL Server Express 2008 management studio

Posted on 2013-12-28
3
700 Views
Last Modified: 2014-01-02
I have installed SQL Server Express 2008 on my Windows server 2008 and when I try to open the management studio the following error pops up:

Cannot connect to {Server name}

A network-related or instance-specific error occured 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 connection to SQL Server) (Microsoft SQL Server, Error: 2)
0
Comment
Question by:mike99c
  • 2
3 Comments
 
LVL 19

Expert Comment

by:Patricksr1972
ID: 39743436
Hi

Open SQL on the server itself and configure to accept remote connections like shown below:
allow remote connections
Next, i expect you to run into the next problem, configure TCP/IP to be enabled and select port 1433 for remote management by executing following steps:

1.Open SQL Server Configuration Manager. Click Start / Programs / Microsoft SQL Server 2008 express / Configuration Tools / SQL Server Configuration Manager.
2.Expand SQL Server Network Configuration / Protocols for [Instance Name]. If you see that TCP/IP protocol status is disabled, right click to Enabled it.

3.Open TCP/IP properties to set the correct listening port:
1.In Protocol / General, set Enabled = Yes.
2.In IP Addresses / IPAll, set TCP Port = 1433 and TCP Dynamic Port = an empty string (to disable the dynamic port).

Lastly, create a firewall rule to allow port 1433 en restart your MSQL Server services.

Now you would be ready to fire off SSMS.
0
 

Accepted Solution

by:
mike99c earned 0 total points
ID: 39743443
It's ok I found out what the issue was. In the login dialog where you have the server name, it should have been of the form:

{Server name}\SQLEXPRESS

I left out the \SQLEXPRESS part.
0
 

Author Closing Comment

by:mike99c
ID: 39750934
I have sincefound out what the issue was and the server name part in the login dialog was not correctly filled in.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

920 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

17 Experts available now in Live!

Get 1:1 Help Now