Post reply

sql 2008 R2 Standard Edition Clustering/ Reporting Services - IIS?

  • March 28, 2011 at 12:57 pm

    #235775

    We are planning to have 2-node active/active clustering for sql 2008 R2 which will also have reporting services on the same database. I do know that SSRS engine is not cluster aware but we want the report db's to be in a cluster. Mentioned below are my questions?

    i) in SSRS 2008 R2 do we still need IIS?

    ii) If we do not need IIS can the web application directly point to this server or we need a webserver?

    Thanks

  • March 29, 2011 at 5:09 am

    #1304762

    sqldba_icon (3/28/2011)

    We are planning to have 2-node active/active clustering for sql 2008 R2 which will also have reporting services on the same database. I do know that SSRS engine is not cluster aware but we want the report db's to be in a cluster. Mentioned below are my questions?

    i) in SSRS 2008 R2 do we still need IIS?

    SSRS does not use IIS console directly, however it does interface with the Http.sys system process behind the scene

    sqldba_icon (3/28/2011)

    ii) If we do not need IIS can the web application directly point to this server or we need a webserver?

    Thanks

    Use the Reporting services 2008 configuration tool to set up the virtual directories and connect to your chosen database instance. It's wizard driven and fairly easy to use.

    Ideally you do not want your SSRS instance installed to a cluster node as the instance will go down if the cluster node is lost

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • March 29, 2011 at 9:14 am

    #1304941

    Thanks. I am not sure what you meant with your second comment "instance will go down is node is lost" wouldnt the sql engine failover to other node ? I know SSRS is not cluster aware but at least the reporting databases are right? Also i would like to know would i need a webserver for my web application if i am using 2008 SSRS?

  • March 29, 2011 at 9:42 am

    #1304972

    sqldba_icon (3/29/2011)

    Thanks. I am not sure what you meant with your second comment "instance will go down is node is lost" wouldnt the sql engine failover to other node ?

    Database engine instance would but SSRS instance wouldnt

    sqldba_icon (3/29/2011)

    I know SSRS is not cluster aware but at least the reporting databases are right?

    what good are the SSRS databases if the virtual dirtectories are not available??

    sqldba_icon (3/29/2011)

    Also i would like to know would i need a webserver for my web application if i am using 2008 SSRS?

    see my previous comment

    No, SSRS 2008 uses the same driver http.sys but does not use IIS to configure\manage the virtual directories, this is done using SQL Server 2008 Reporting Services Configuration tool

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 4 posts - 1 through 4 (of 4 total)

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