Configure Reporting Service in a SQL Server 2005 Cluster

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Configure Reporting Service in a SQL Server...

Configure Reporting Service in a SQL Server 2005 Cluster

Rate Topic

Display Mode

Topic Options

Author

Message

Richard Long

Posted Thursday, October 02, 2008 1:43 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 10:07 PM
Points: 12, Visits: 156

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

Maxer

Posted Thursday, October 02, 2008 8:22 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, September 21, 2012 9:22 AM
Points: 250, Visits: 815

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

John Najarian-387971

Posted Saturday, February 06, 2010 6:58 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, February 15, 2013 4:38 PM
Points: 13, Visits: 248

Did anyone get this to work? Thanks

Post #861234

sscheider

Posted Thursday, June 28, 2012 3:25 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, February 01, 2013 10:05 AM
Points: 5, Visits: 8

Any details of this effort would be greatly appreciated!

Post #1322765

anthony.green

Posted Friday, June 29, 2012 2:47 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 2:40 AM
Points: 5,075, Visits: 4,833

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 »

Permissions