SQL Server 2005 - Install Problems 'Reporting Services must be able to connect to a SQL Server Instance'
Posted on 2009-04-14
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 - !  SQLServer Error: 2, Named Pipes Provider: Could not open a connection to SQL Server . [SQLSTATE 08001]
2009-04-14 12:33:47 - !  ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
2009-04-14 12:33:47 - !  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 - !  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?