Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 reporting services is not cluster aware

Author  Topic 

ajay_uiet
Starting Member

9 Posts

Posted - 2009-12-31 : 04:52:49
Dear All,

I have SQL server active active cluster.Install on both but on machine2 I have configured the reporting services.machine2 is down these days and I am not able to access reporting services using these URLs

http://10.1.96.56/Reports
http://10.1.96.56/Reportserver

Error comes one by one:

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help 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. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

----------------------------------------------------------------------------------------------------


Reporting Services Error

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help
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. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

SQL Server Reporting Services
   

- Advertisement -