?
Solved

SQL Server Access Problem

Posted on 2011-03-16
5
Medium Priority
?
390 Views
Last Modified: 2012-05-11
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
Comment
Question by:dwcummings
[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
  • 3
  • 2
5 Comments
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35151848
You should connect to <your server name>\SQLEXPRESS
0
 
LVL 3

Author Comment

by:dwcummings
ID: 35157120
Thanks for responding. However, I have tried your suggestion and I still cannot access the database with Management Studio.
0
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35157162
Sorry for asking but can you verify that sql server services are running in sql server configuration manager?
0
 
LVL 3

Author Comment

by:dwcummings
ID: 35157325
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
 
LVL 14

Accepted Solution

by:
Daniel_PL earned 2000 total points
ID: 35230440
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

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

In this article I will describe the Detach & Attach 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.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

770 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