locked
SQl Server failover Cluster 2012 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Dear Experts,

    I had a 2 node SQl 2008 cluster and I have upgarde it to SQL 2012 cluster.

    I also need to add other features like SSAS, SSIS to the same cluster. When i tried doing that, I received an error similar to the one described here.

    http://stackoverflow.com/questions/1160179/add-analysis-services-to-a-clustered-sql-server-2008-instance

    As per the doumentation of SQL 2008 Failover cluster, we cant add features to a SQL 2008 cluster.
    Is adding feature functionality available on SQL 2012 or it is also same as SQL 2008? Because I want to add SSAS 2012 to the existing Database Engine cluster setup and I am looking for a way to do that.

    Thanks,

    Thanks

    Monday, January 28, 2013 10:13 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Configure the Integration Services Service as a Cluster Resource

    Additionally, from Integration Services (SSIS) in a Cluster "Clustering Integration Services is not recommended because the Integration Services service is not a clustered or cluster-aware service, and does not support failover from one cluster node to another. Therefore, in a clustered environment, Integration Services should be installed and started as a stand-alone service on each node in the cluster."

    Please use Marked as Answer if my post solved your problem and use Vote As Helpful, if a post was useful to help other user's find a solution quicker.

    • Proposed as answer by Fanny Liu Tuesday, January 29, 2013 7:00 AM
    • Marked as answer by Fanny Liu Monday, February 4, 2013 2:00 AM
    Monday, January 28, 2013 12:03 PM

All replies