SQL Server Performance

Reporting Services on a cluster

Discussion in 'SQL Server Reporting Services' started by Savoy, Oct 6, 2005.

  1. Savoy New Member


    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?
  2. suleman New Member

    hi savoy

    plz tell me the purpose of the setup...

  3. Savoy New Member

    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..
  4. suleman New Member

    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...<br /><br /><br />Regards<br />Suleman<br />Hyderabad
  5. Savoy New Member

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


Share This Page