Solved

SQL Server Access Problem

Posted on 2011-03-16
5
387 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
  • 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 500 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

840 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