October 2, 2008 at 1:43 am
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
October 2, 2008 at 8:22 am
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.
February 6, 2010 at 6:58 pm
Did anyone get this to work? Thanks
June 28, 2012 at 3:25 pm
Any details of this effort would be greatly appreciated!
June 29, 2012 at 2:47 am
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.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply