June 20, 2008 at 1:29 pm
We have an active/active cluster with sql 2005 ent edition, that needs reporting services for a 3rd party app. Do we need to install reporting services on each instance?
June 20, 2008 at 2:11 pm
SQL Server 2005 provides failover clustering support so that you can use multiple disks for one or more SQL Server instances. Failover clustering is supported only for the report server database; you cannot run the Report Server Windows service or Web service as part of a failover cluster.
To host a report server database on a SQL Server failover cluster, the cluster must already be installed and configured. You can then select the failover cluster as the server name when you create the report server database.
Although the Report Server Windows service and Web service cannot participate in a failover cluster, you can install Reporting Services on a computer that has a SQL Server failover cluster installed. The report server runs independently of the failover cluster. If you install a report server on a computer that is part of a SQL Server failover instance, you are not required to use the failover cluster for the report server database; you can use a different SQL Server instance to host the database.
Quoted from: http://msdn.microsoft.com/en-us/library/ms157293.aspx
Also see:
http://www.lockergnome.com/sqlsquirrel/2008/01/02/reporting-services-on-a-cluster/
Brad M. McGehee
DBA
June 20, 2008 at 2:27 pm
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply