subscriptions in clustered enviornment

We are running sql 2005 in a 2 node active /passive cluster.Reporting services being installed on 2 nodes separately.
The problem that we are facing is when we add new subscriptions they tend to point to the node whichever is active.
So when a failover occurs and we add more subscriptions to it the new subscriptions added now points to the failed  over node.Which finally ends up some subscriptions in node 1 and some pointing to node 2.
Is there any way we can merge the subscriptions to point to one node?
LVL 8
venk_rAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim P.Commented:
Everything I'm reading is saying that the Reporting Services are not normally clusterable. But the first link below is talking about how to do it with SQL 2000. I'm sure you can pull it of with 2005.

It looks to be a matter of shifting your IIS and Reporting services install to a clustered LUN.

How to do it:
Clustering Reporting Services
http://www.sqlservercentral.com/articles/Administration/clusteringreportingservices/2398/

Saying it can't be done:
-------------------------------------------
Hosting a Report Server Database in a SQL Server Failover Cluster
http://technet.microsoft.com/en-us/library/bb630402.aspx
0
venk_rAuthor Commented:
Thanks for your reply. Probably I wasnt that clear on the issue. The only help I need is how would I migrate the reporting services to a different server and update the datasource. Now that I am having 2 different sets of subscription on each node . If i backup the encryption keys  that would point to node 1 and restore it over the migrated server and then backup the encryption keys on node 2 and restore them respectively wouldnt it overwrite the existing configuration on the migrated server?
0
Jim P.Commented:
The only thing I can think is that you are going to have separate the reporting services from the SQL cluster and then recreate the other subscriptions.

Note that I have very little experience with RS. TPTB haven't let me play with them. :-(
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim P.Commented:
Glad to be of assistance. May all your days get brighter and brighter.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.