Home Forums Reporting Services SSRS 2012 Clustered install of Reporting services - 2 nodes RE: Clustered install of Reporting services - 2 nodes

  • October 1, 2014 at 10:20 pm

    #1749581

    johnnyrmtl (10/1/2014)

    Hello all,

    This is my first experience with this type of installation and it seems a bit tricky .

    I have two nodes of a windows 2012 cluster with an install of an SQL Instance cluster along with SSRS and SSAS.

    The problem is that since Reporting services cannot be clustered and it will only run on node 1, how to I install on node #2 for a failover ?

    The SSRS database portion is fine as it will move with the failover.

    any tips or experiences ?

    Many thanks

    JR

    First, I would not normally install SSRS onto a cluster. To scale out for either performance or availability, check out the "Scale out deployment" option in the SSRS configuration tool. This allows you to configure a second instance of SSRS to use the same SSRS databases. Adding a load balancer over the top of the SSRS servers should allow you to automatically route traffic to either of these servers.