[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 814
  • Last Modified:

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?
0
jordaaaa
Asked:
jordaaaa
  • 6
  • 5
1 Solution
 
EvilPostItCommented:
Look at scale out reporting. This is how you implement load balanced reporting services server.

Have a look at the below.

http://sqlcat.com/sqlcat/b/technicalnotes/archive/2008/06/05/reporting-services-scale-out-architecture.aspx
0
 
jordaaaaAuthor Commented:
Very interesting technical notes!
I still have a lot to digest but perhaps you can speed it up.
So:
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.
0
 
EvilPostItCommented:
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.
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
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
0
 
EvilPostItCommented:
There shouldnt be any databases on the SSRS servers. Just the database cluster.
0
 
jordaaaaAuthor Commented:
Then im confused. To install SSRS I must install a SQL Instance
0
 
EvilPostItCommented:
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.
0
 
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
0
 
jordaaaaAuthor Commented:
How to: Install a Local Report Server and Remote Report Server Database

http://msdn.microsoft.com/en-us/library/ms143703(v=sql.90).aspx

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

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now