Cannot connect to MSSQLSERVER when Installing SQL Server 2008

Posted on 2010-01-10
Medium Priority
Last Modified: 2012-05-08
I installed SQL Server 2008 on my Acer Aspire 5739G notebook. I installed a default instance but named it "SQL2008A".  But when I tried to connect to the server, I received the message "Cannot connect to MSSQLSERVER. A Network-related instace-specific error occurred while establishing a connection SQL Server. Provider" Named Pipe Provider, error: -40. Could not open a connection to SQL Server. MS SQL Error 53.
Question by:shellybelly999
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
LVL 11

Accepted Solution

ashraf882 earned 668 total points
ID: 26280723
Check from service list that your instance is running properly.
Then try to connect again.
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 668 total points
ID: 26280731
>> I installed a default instance but named it "SQL2008A"

A Default instance should be the Servername.
Kindly try connecting the server by servername\SQL2008A and if it works then you have installed a named instance and not default instance..

Kindly confirm..
LVL 30

Assisted Solution

by:Reza Rad
Reza Rad earned 664 total points
ID: 26280737
1- if you installed default instance then you can not set a name for your instance, and your sql 2000 instance will be upgrade to 2008.
2- what edition of sql server 2008 you installed?
3- go to this address:
microsoft sql server 2008
configuration tools
sql server configuration manager
select sql server 2008 services in left panel
list of services will appear in right panel
take an screenshot of this window and upload it here
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.


Author Comment

ID: 26280942
I'm running the Developer edition of SQL Server 2008. I set up a standard user and added a password. I used the standard user for all accounts.

Author Comment

ID: 26280961
I also should mention that I uninstalled SQL Server 2008, then reinstalled it to make sure I used the Default instance. The second time I didn't change the name. I left it as MSSQLSERVER.
LVL 57

Expert Comment

by:Raja Jegan R
ID: 26280963
Just try connecting it as MSSQLSERVER..

And kindly check whether you have enabled remote connections correctly as per:


Author Comment

ID: 26280976
Thanks rjegan17! You hit the nail on the head! I was using the name MSSQLSERVER when I should've been using the name of the computer. Now it works.
LVL 57

Expert Comment

by:Raja Jegan R
ID: 26281004
And glad to help you out..

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

800 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