SQL Server Performance Forum – Threads Archive

Reporting Services on a cluster

Hi, I am not able to install Reporting Services (RS) on a Web Farm, but would like to get it installed and configured on Failover Cluster. What do you think about the following scenario? 1.Install RS on one server and create the databases on the SQL Server Cluster.
2.Install RS on the second server.
3.Configure the second RS to use the clustered database.
4.Copy the encryption key from the RS installation that created the databases.
5.Apply the encryption key to the RS installation that did not create the database.
6.Create RS service as a generic service for the Cluster.
I have not tested this yet, but in theory it should work? or?
Savoy

hi savoy plz tell me the purpose of the setup… Regards
Suleman
Hyderabad

The purpose of the setup is to make RS part of a active/passive failover cluster. I am aware of the solution to create a web farm to use the cluster, but I would like only to use the two servers in the cluster and not involve a web farm. Hope this make sense..

oh iam helpless here… even i know till the web farm but not without it…<img src=’/community/emoticons/emotion-6.gif’ alt=’

‘ /> plz lemme know when u get the solution… Regards Suleman Hyderabad

ok… Hopefully I will get a change to test it and will post here when completed. Cheers

]]>