SSRS 2012 Clustered with Sharepoint 2010
Posted on 2012-08-15
I would like to have a Load balanced (NLB) SSRS installation with the ReportServer on the FO cluster.
My environment is as follows:
2 x SQL 2012 Clustered servers (with SSRS scaled out) (Fail Over Cluster)
4 x SP APPS Server (running a mix of SP services)
4 x SP WEB (WFE) (NLB)
It is my understanding that SP will Load balance on the APPS server level.
The WFE will distribute client requests between them (using NLB) and thus balance across the APPS servers and the SQL Cluster
Now I would like to add SSRS.
Installing on the SQL servers is not a problem except that it is not load balanced.
I am thinking in the line of installing a SSRS component on the WFE servers, with the URL load balanced via NLB and pointing to the same SSRS database on the SQL cluster.
In other words.
I want a single URL for reportserver (and to be used in the SP service) that offers some failover and load balancing.
Is this possible?