March 26, 2012 at 10:53 am
Hi,
As SSRS 2008 doesn't use IIS anymore but connects directly to http.sys, shouldn't it be possible to cluster SSRS ?
I'm wondering about the following steps:
1. Create a clustered drive and run SQL Server setup. install SSRS on one node and as feature selection, install on clustered drive.
2. Create the cluster network name and give an IP.
3. Create the cluster group to contain the reporting service and specify the registry tree folder to duplicate/synchronise (don't what that is for SQL 2008. It's on MSDN for 2000 but i can't imagine it'd be the same for 2008...)
4. Alter all configuration files to reflect the IP and/or network name specified in the group. (I think/hope all relevant files are specified here http://msdn.microsoft.com/en-us/library/ms155866.aspx)
Anyone know if I missed something on the high-level scheme of steps ? Are there any files/binaries installed on the root drive anyway so I'd have to install SSRS on both nodes?
Thanks for feedback !
March 27, 2012 at 3:35 am
update: can't find any guidance on the required files on the root directory... Anyone have any experience on this ?
March 29, 2012 at 11:51 am
The components of Reporting Services can be installed anywhere including both nodes, it's database can be on the clustered sql server, but the failover between the components of SSRS does not support clustering for creating an automated or passive failover. There are some things you can do to check availability of the SSRS service if your wrapping in your own application which can make it seem to be clustered but there is no direct clustering technology within SSRS.
April 2, 2012 at 4:06 am
Clustering for SSRS will give you a high-availability solution. It is not a scale-out solution because only one instance of SSRS can be active at a given time on the cluster.
The process of clustering SSRS is not documented by Microsoft, and very little advice exists for doing this.
Take a look at http://brodaric.blogspot.com/2011/04/installing-sql-server-2008-r2-reporting.html I have also seen another post that describes how to manually apply the same SSRS encryption key to all instances on the cluster, butt cannot finf this now.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply