SSRS 2012 Clustered with Sharepoint 2010

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?
Who is Participating?
EvilPostItConnect With a Mentor Commented:
Look at scale out reporting. This is how you implement load balanced reporting services server.

Have a look at the below.
jordaaaaAuthor Commented:
Very interesting technical notes!
I still have a lot to digest but perhaps you can speed it up.
I need to translate these docs into something practical for me....

With NLB on these WFEs doing load balancing
It seems I need a SSRS installation on each WFE pointing to the central ReportsServer (Report Catalog) that is currently on the SQL Cluster.
Then Scaling Out the WFE SSRS installation(s) - (I needed to export the keys from the existing SSRS install on the SQL cluster and restore it to the WFE SSRS installations.
Is this the idea?

I am not yet sure how exactly SSRS functions re caching and keeping state for queries /parameters.
The SSRS install is separat to the database cluster install. You effectively have a single database server on one machine and then you have separate SSRS installations on smaller webserver like machines (SSRS installs a cut down version of its own built in web browser). These SSRS servers then connect back to a single database on your database cluster. The keys which have to be restored are only across the SSRS servers.

To view SSRS from sharepoint you may need the Sharepoint SSRS webparts.
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

jordaaaaAuthor Commented:
The only database(s) on the SSRS servers I can see is the usual System Databases (Master etc)
I assume the SSRS configs are stored in there, and that SSRS will cache data in these temp dbs.

The Report Catalog is still on the Clustered Database

Im going to install all of this now and re read those tech notes.
Many thanks
There shouldnt be any databases on the SSRS servers. Just the database cluster.
jordaaaaAuthor Commented:
Then im confused. To install SSRS I must install a SQL Instance
No, you can install the SSRS application on its own and connect to a pre-existing SQL Server database instance.

You then install multiple SSRS instance on separate machines and join them to the same farm. This is done through Reporting Services Configuration Manager.
jordaaaaAuthor Commented:
Sorry I was busing editing my previous comment.

I cannot see a way to install the SSRS application on its own
SQL setup insists on an Instance.

I cannot seem to get this to connect to an Instance on another server
jordaaaaAuthor Commented:
How to: Install a Local Report Server and Remote Report Server Database

Will try now
Yep, thats the one. Are you using SQL Server 2005?
jordaaaaAuthor Commented:
Its SQL server 2012 but its the same idea.
Thanks got it installed and connected.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.