Solved

subscriptions in clustered enviornment

Posted on 2009-07-14
4
325 Views
Last Modified: 2012-05-07
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?
0
Comment
Question by:venk_r
  • 3
4 Comments
 
LVL 38

Expert Comment

by:Jim P.
ID: 24848861
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
 
LVL 8

Author Comment

by:venk_r
ID: 24849522
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
 
LVL 38

Accepted Solution

by:
Jim P. earned 500 total points
ID: 24849873
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
 
LVL 38

Expert Comment

by:Jim P.
ID: 24959989
Glad to be of assistance. May all your days get brighter and brighter.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
What is the best way to calculate hours worked 5 69
Help with SQL joins 9 48
Analysis of table use 7 47
Error in SSIS while executing  - Potential data loss 4 23
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question