Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Configure Reporting Service in a SQL Server 2005 Cluster Expand / Collapse
Author
Message
Posted Thursday, October 2, 2008 1:43 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, March 7, 2014 1:53 AM
Points: 12, Visits: 175
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
Post #579508
Posted Thursday, October 2, 2008 8:22 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 2:45 PM
Points: 272, Visits: 1,086
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.
Post #579675
Posted Saturday, February 6, 2010 6:58 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 21, 2013 5:31 PM
Points: 13, Visits: 252
Did anyone get this to work? Thanks
Post #861234
Posted Thursday, June 28, 2012 3:25 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 1, 2013 10:05 AM
Points: 5, Visits: 8
Any details of this effort would be greatly appreciated!
Post #1322765
Posted Friday, June 29, 2012 2:47 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:54 AM
Points: 5,149, Visits: 4,961
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.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1322923
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse