Solved

SQL Server 2005 Installation

Posted on 2011-10-31
9
189 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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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

Suggested Solutions

Title # Comments Views Activity
SQL help 5 53
sql Audit table 3 66
upgrade sql 2005 32bit to sql 2008 32 or 64bit on a server 2008 r2 box 6 63
SQL query with cast 38 42
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
In this article I will describe the Copy Database Wizard 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.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

813 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now