TedgCl
asked on
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.