Home > SSRS > How you can make the Reporting service is a cluster aware

How you can make the Reporting service is a cluster aware


As we know Reporting Services is not cluster aware, regardless of what Edition you are running. Though the databases can be installed on Clustered SQL Server instances and will fail over successfully, the Reporting Services service itself is not cluster aware and will need to be installed on all servers in the cluster.

To host a report server database on a SQL Server failover cluster, the cluster must already be installed and configured. You can then select the failover cluster as the server name when you create the report server database. Although the Report Server Windows service and Web service cannot participate in a failover cluster, you can install Reporting Services on a computer that has a SQL Server failover cluster installed. The report server runs independently of the failover cluster.

Step Need to follow :Assume the name of the SQL cluster is VSQL and the cluster nodes are A1 and A2.

  1.       Install IIS and RS on the default instance, MSSQLServer, on both A1 and A2.
  2.       On the A1 – Configure the RS to create the RS databases on the SQL cluster and RS server name as VSQLReports.
  3.       On the A2 – with the same RS server name and V2, Configure the RS to connect the previously created Report Server and ReportServerTempDB.
  4.       Make sure to use the same Window Service ID on both nodes
  5.       The Web Service Identity is NT Authority\NetworkService
  6.       As RS is not the cluster aware, so both of the RS services should be Started
  7.       When connect to the RS, it will be something like http:// VSQLReports /reports/
Advertisements
  1. Brian
    January 12, 2015 at 3:30 pm

    To connect more SSRS instances to the same SSRS databases is called scale-out which is an enterprise feature if I remember correctly. Also, you would have to license both nodes in the cluster if you have SSRS running on both.
    Apart from that, how do you control which SSRS your clients connect to without some sort of external failover mechanism? What you have done here as it seems, is simply scale-out deployment of SSRS where your client connects to one of the SSRS instances. If one of them fails, you will have to point your clients to the other.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: