Reporting Services in SQL 2005 cluster

Posted on 2009-02-09
Last Modified: 2012-05-06
We have reporting services installed on both of the cluster nodes(Active ,Passive).
unfortunately we cannot rely on it as  it does reside as part of cluster.if at all we include it in the cluster then we have the risk of the whole cluster getting failed when the report services fail. So Whats the best way to implement the reporting services in cluster?
Question by:venk_r
    LVL 41

    Assisted Solution

    Reporting Services is not aware of Microsoft Cluster Services. Please see this link:
    LVL 8

    Accepted Solution

    I know reporting services is not aware of the cluster services.I am just asking what would be the workaround in the current environment.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now