Monday, 20 January 2014

Installing SQL Server Reporing Services onto a cluster

SQL Server Reporting Services (SSRS) is not cluster aware - it isn't possible for the web front end of SSRS to fail over with a cluster. It is, however, possible to install an instance of SSRS onto each node of a cluster, and then point each instance to a shared, clustered ReportServer database using the Scale Out functionality of SSRS. This option is only available in Enterprise Edition. 

However, it is not recommended to install SSRS onto a SQL Server cluster, due to competition between SQL Server and SSRS for resources etc.

More information here: http://blogs.msdn.com/b/psssql/archive/2010/05/27/reporting-services-scale-out-and-clusters.aspx

No comments:

Post a Comment

Updating massive amount of rows whilst avoiding blocking

The following SQL is a good means to split an update on a massive table into smaller chunks, whilst reducing blocking. The method is to upda...