Solved

Cannot open SQL Server Express 2008 management studio

Posted on 2013-12-28
3
712 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 22

Expert Comment

by:Patrick Bogers
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

726 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