﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>SQLServerCentral / Administering / SQL Server 2005  / Configure Reporting Service in a SQL Server 2005 Cluster / Latest Posts</title><generator>InstantForum.NET v2.9.0</generator><description>SQLServerCentral</description><link>http://www.sqlservercentral.com/Forums/</link><webMaster>notifications@sqlservercentral.com</webMaster><lastBuildDate>Sat, 25 May 2013 21:45:06 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: Configure Reporting Service in a SQL Server 2005 Cluster</title><link>http://www.sqlservercentral.com/Forums/Topic579508-146-1.aspx</link><description>SSRS isnt cluster aware, but you could use scale out deployments if you have SQL Enterprise or some form of load balancing as its based on IIS.Be careful when you upgrade past 2005 as SSRS is no longer IIS based in 2008 onwards are requires other load balancing techniques.</description><pubDate>Fri, 29 Jun 2012 02:47:35 GMT</pubDate><dc:creator>anthony.green</dc:creator></item><item><title>RE: Configure Reporting Service in a SQL Server 2005 Cluster</title><link>http://www.sqlservercentral.com/Forums/Topic579508-146-1.aspx</link><description>Any details of this effort would be greatly appreciated!</description><pubDate>Thu, 28 Jun 2012 15:25:09 GMT</pubDate><dc:creator>sscheider</dc:creator></item><item><title>RE: Configure Reporting Service in a SQL Server 2005 Cluster</title><link>http://www.sqlservercentral.com/Forums/Topic579508-146-1.aspx</link><description>Did anyone get this to work? Thanks</description><pubDate>Sat, 06 Feb 2010 18:58:57 GMT</pubDate><dc:creator>John Najarian-387971</dc:creator></item><item><title>RE: Configure Reporting Service in a SQL Server 2005 Cluster</title><link>http://www.sqlservercentral.com/Forums/Topic579508-146-1.aspx</link><description>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.</description><pubDate>Thu, 02 Oct 2008 08:22:19 GMT</pubDate><dc:creator>Maxer</dc:creator></item><item><title>Configure Reporting Service in a SQL Server 2005 Cluster</title><link>http://www.sqlservercentral.com/Forums/Topic579508-146-1.aspx</link><description>Hi,I have setup a 2 node SQL Server 2005 Cluster on Windows Server 2003 Ent Edition. Svr1 is active node, Svr2 is passive.I also have run Reporting Service set-up in the nodes. My questions: 1) How to configure RS on this cluster? Can we have RS failed over in case of one node fails?2) After configure RS, how to access the Reports -- Http://VirtualServer/Reports or http://Svr1/Reports?Any advice is highly appreciated.Richard Long</description><pubDate>Thu, 02 Oct 2008 01:43:55 GMT</pubDate><dc:creator>Richard Long</dc:creator></item></channel></rss>