Database Reference
In-Depth Information
Implementing Scale-Out deployment of SQL
Server Reporting Services
There are various deployment modes available with SQL Server Reporting Services; the recipe
Preparing
and
Installing
Reporting
Services
highlights the new deployment mode that is
available in SQL Server 2008 R2. Similar to the core database engine and analysis services,
the reporting services can also be deployed as a scale-out model by configuring the multiple
report servers to use a share report server database.
To provide further high availability to the reporting services platform, you might decide to
host the report server database on SQL Server failover cluster nodes. The advantage of this
scale-out deployment is a highly available and scalable reporting services platform. In this
deployment mode, each report server is referred to as a node. Nodes participate in the scale-
out, if the report server is configured to use the same remote report server database. The
load balancing of reports is managed by the load balancer component.
In this recipe, we will go through the required steps and tools to configure a
scale-out deployment.
Getting ready
There are certain requirements that apply for a reporting services scale-out deployment. They
are as follows:
F
. NET framework 3.5 SP1, Windows Install 4.5, and SQL Server setup support files
that are still applicable to Reporting Services installation
F
Run Setup to install an instance of Reporting Services, choose the Install but do not
configure server option on the Installation Options page
F
Only Enterprise Edition is supported to deploy the scale-out configuration in a
production environment
F
All the report servers must have the same version of SQL Server including service
pack updates
F
The reporting services authentication must be the same across all the report
server instances
F
Report server nodes can be load-balanced using Network Load Balanced (NLB)
cluster software from the operating system
Search WWH ::
Custom Search