Home Forums SQL Server 2005 Administering Configure Reporting Service in a SQL Server 2005 Cluster RE: Configure Reporting Service in a SQL Server 2005 Cluster

  • If memory serves report services is really just running inside IIS.

    So I BELIEVE you could actually setup a stand alone IIS web server and have it host reporting services. Then use whatever the best practices for IIS web server clustering/fail over/etc... are for IIS.

    The Report Server database would of course still be on your SQL Server cluster and then it would do whatever other databases in a cluster do.

    I THINK that is how that would work.

    So if you configured reporting services on each node of the cluster, I think if you check then IIS will be running on each node... so that may NOT be what you are really after...

    Do not quote me on any of this, I'm just thinking back to when I setup our SSRS installation.