Solved

SQL Server 2005 Installation

Posted on 2011-10-31
9
190 Views
Last Modified: 2012-05-12
I am trying to install a local copy of SQL Server 2005.  I have sql server 2008 SMS installed on the client which connects to a SQL Server 2008 R2 database.  I name the database instance.  When i try to connect using Windows Authentication and also the name of the Database tthat I created I receive the below error:

"A network-related or instance-specific error occurred while establshing 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 Servder, Error : 1326)

Any idea how to fix?
0
Comment
Question by:CipherIS
  • 5
  • 4
9 Comments
 
LVL 34

Expert Comment

by:Paul MacDonald
ID: 37058138
Can you connect by IP address?  Also, is the local firewall set up to allow connections to the local SQL Server instance?
0
 
LVL 1

Author Comment

by:CipherIS
ID: 37058240
Got IP from IPConfig and can't connect.  
0
 
LVL 34

Expert Comment

by:Paul MacDonald
ID: 37058314
It seems likely either your firewall it's blocking the client or SQL Server isn't configured to use TCP/IP.
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 34

Expert Comment

by:Paul MacDonald
ID: 37058315
It seems likely either your firewall it's blocking the client or SQL Server isn't configured to use TCP/IP.
0
 
LVL 1

Author Comment

by:CipherIS
ID: 37058397
when i do

ping -a servername

it pings
0
 
LVL 1

Author Comment

by:CipherIS
ID: 37058478
SQL Server Browser is stopped and can't be started.  Is this an issue?
0
 
LVL 1

Accepted Solution

by:
CipherIS earned 0 total points
ID: 37058565
i resoled it - thx
0
 
LVL 1

Author Closing Comment

by:CipherIS
ID: 37087296
Figured it out
0
 
LVL 34

Expert Comment

by:Paul MacDonald
ID: 37058614
Points aside, can you share the fix?  It may help someone else...
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

837 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