• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 398
  • Last Modified:

SQL Server Access Problem

I just installed SQL Server 2008 R2 Express on a Windows 2008 server. When I attempt to access the server with SQL Server Management Studio, I get the following error message:

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)
0
dwcummings
Asked:
dwcummings
  • 3
  • 2
1 Solution
 
Daniel_PLDB Expert/ArchitectCommented:
You should connect to <your server name>\SQLEXPRESS
0
 
dwcummingsAuthor Commented:
Thanks for responding. However, I have tried your suggestion and I still cannot access the database with Management Studio.
0
 
Daniel_PLDB Expert/ArchitectCommented:
Sorry for asking but can you verify that sql server services are running in sql server configuration manager?
0
 
dwcummingsAuthor Commented:
Yes, I have 2, which maybe the source of the problem. SQLExpress and Doorways (the company name). I originally installed SQL Server 2005 Express and then installed SQL Server 2008 Express after removing 2005. However, it didn't seem to completely uninstall the 2005 version and one of the services is a reminent of the 2005 installation.
0
 
Daniel_PLDB Expert/ArchitectCommented:
Please look into Programs and Features in Control Panel to find if any SQL Server 2005 entries are there.
Could you post results from following:

start->run-> (type) cmd

sc query |findstr "SERVICE_NAME"|FIND "MS"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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