?
Solved

Cannot open SQL Server Express 2008 management studio

Posted on 2013-12-28
3
Medium Priority
?
741 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 23

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

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.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Suggested Courses

764 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