Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 788
  • Last Modified:

Cannot open SQL Server Express 2008 management studio

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
mike99c
Asked:
mike99c
  • 2
1 Solution
 
Patrick BogersDatacenter platform engineer LindowsCommented:
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
 
mike99cAuthor Commented:
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
 
mike99cAuthor Commented:
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now