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  High Availability (2005)  Reporting servers web farm

Author  Topic  SQLSpeck Starting Member 1 Post Posted - 2009-06-09 : 17:01:42 Hi, Instead of using NLB web farm to house the reporting service (IIS and ASP.NET) and keeping the Reporting databases on a cluster, the following article explains Clustering of SSRS by having both Reporting servers (IIS and ASP.NET) and the databases on the same cluster. But the process explained is for Active\Passive configuration http://www.sqlservercentral.com/articles/Administration/clusteringreportingservices/2398/ Could anyone tell me whether this also works for Active\Active configuration also because I don’t have any test environment to test this approach? Have anyone tried this approach for the Active\Active cluster? In the article it was not clearly mentioned about when does the “Report Server Web farm screen” appears. It was mentioned that “upon pointing the reporting databases to the clustered SQL Server, the Web Farm Setup screen appears”. But during the installation of SSRS we don’t point the databases to the already existing SSRS databases. We do that during the configuring of SSRS, using the Reporting Services Configuration tool. So is it during this configuration that we get that screen? Am I correct? Thanks, Yours SQLSpeck