dbTalk Databases Forums  

Reporting Services on a Cluster

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.clustering Reporting Services on a Cluster

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Reporting Services on a Cluster in the microsoft.public.sqlserver.clustering forum.



Reply
Page 2 of 2 < 1 2
 
Thread Tools Display Modes
  #11  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Reporting Services on a Cluster - 04-16-2008 , 03:41 PM





RS does not cluster. It is a stateless application and does not need to
cluster.

You can install RS on the other node and join it to the existing RS instance
so they work in a web farm type of situation. The back-end RS databases
manage state so they appear as one instance. NLB is fine for just a few
servers.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Pearl" <Pearl (AT) discussions (DOT) microsoft.com> wrote

Quote:
Greetings all,

We need some help understanding our options. We have a 64bit W2003 SP2 &
SQL 2005 SP2 currently running as a single instance.
We know that Reporting Services (RS) is not cluster aware. We currently
have RS running on the inactive node & SQL Server running on the active
node.
I'd like to understand how this happened and how to correct it. I believe
the RS difference noted is because we performed a manual failover to test
the
cluster and because RS is not cluster aware it continues to run on the
inactive server. Is this correct.

Now on to what we can do about it. Our thoughts are:
1. Failover the server to the inactive node so SQL Server & RS are both
running on the active server.
2. Remove the inactive node out of the SQL cluster & rebuild it -
including
an RS installation that mirrors the now active server's installation.
3. Add the rebuilt server back into the cluster. (is there a link
available
to this procedure?)
*Is the above a viable solution?
Is there a software release for RS already at SP2? Or is it only
available
at SP1 level? We had tried this first on a stand-alone test server and
the
RS install failed because we were trying to install a version (SP1) older
than the currently installed SQL Server version (SP2).
Is RS cluster aware in SQL 2008?
How does it work and is there an available procedure/link for changing the
single instance cluster to a multi-instance cluster? How about from a
single
instance cluster to an N+1 cluster?
Is it correct to perform the SQL install on the server node prior to
adding
it to the existing cluster? How does this work? Otherwise, how do they
sync
up, and use the shared array?

Thanks in advance for any assistance you can provide!
- Lori


Reply With Quote
Reply
Page 2 of 2 < 1 2

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top