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

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?

Who is Participating?
TedgClConnect With a Mentor Author Commented:
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



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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.