Post reply

Clustering SSRS

  • July 22, 2009 at 9:05 am

    #136588

    Hi,

    Could anyone tell me the steps to setup SSRS web farm on a windows NLB cluster in order to provide HA for SSRS?

    Thank You,

    Yours,

    SQLBuddy

  • July 23, 2009 at 4:23 am

    #1028835

    As far as I am aware, SSRS is not cluster aware so you would need to install it (and IIS - unless you are using SSRS 2008 which has dispensed with the need for IIS) on each node. If a failover occurred the ReportServer localhost connection would need to be changed to point at the active node.

  • July 23, 2009 at 7:36 pm

    #1029414

    Hi Lempster,

    Thank you very much for your reply.

    You are right. Actually there are 2 approaches to install ssrs on a cluster.

    First method is to install SSRS on each of the node and then setup an internal web farm of report servers.

    Second method is to install Report servers on an external webfarm. This is called scaled out deployment.

    But unfortunately, first method, the method which you are referring to is not supported by microsoft.

    Thank You,

    Yours

    SQLBuddy.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply