?
Solved

SQL Server 2005 - Install Problems 'Reporting Services must be able to connect to a SQL Server Instance'

Posted on 2009-04-14
1
Medium Priority
?
556 Views
Last Modified: 2012-06-21
I uninstalled SQL Server 2005 x64, rebooted and am trying to reinstall SQL Server 2005.  The install hangs at the point where it is trying to configure the compents I selected.  The error message it gives is "Cannot connect to the SQL server instance"  "Reporting services must be able to connect to a SQL server instance".  I verified the I AM ABLE TO connect to the SQL server instance using SQL server management studio installed on a different machine.  

I also noticed that I can't start the SQL server Agent.  It is failing with:

2009-04-14 12:33:47 - ! [298] SQLServer Error: 2, Named Pipes Provider: Could not open a connection to SQL Server [2]. [SQLSTATE 08001]


2009-04-14 12:33:47 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]

2009-04-14 12:33:47 - ! [298] SQLServer Error: 2, An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. [SQLSTATE 08001]

2009-04-14 12:33:47 - ! [000] Unable to connect to server 'UCI01\EOD_SQL'; SQLServerAgent cannot start

However, I can connect to 'UCI01\EOD_SQL' fine with SQL server management studio.  What is the problem?

0
Comment
Question by:TedgCl
[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
1 Comment
 

Accepted Solution

by:
TedgCl earned 0 total points
ID: 24144477
Located the problem.  For whatever reason, (none of my other servers needed this), you need to modify this registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\SQLServerAgent\ServerHost

Set the ServerHost to either:
1) YourServerName

or

2) SERVERNAME\INSTANCE

This should allow you to get SQLServerAgent running.

Next, I created ab alias that I have no idea if this helped fix the problem or not.
1) INSTANCE pointing to YourServerName\INSTANCE

Then, I restarted the SQL server and tried hitting refresh on the reporting services installer.  

This worked for me.
0

Featured Post

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

752 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