Way to Install Sql Server Integration Services (IS) and Notification Services (NS) on Fail Over Cluster Environment

I'd like to brief the steps for IS and NS Set up on Clusters:

  1. Add MSDTC as a Clustered Service before starting the IS and NS Installation. Distributed Transaction Coordinator service should be running on both the nodes.
  2. Deploy the SSIS and NS installation separately on both the nodes. One must be in active mode and the other in Passive mode while installing.
  3. Apply Service Pack 2A and Cumulative Hot fix Latest build (Recommended for boxes running analysis Services also, Prevents memory leakage, Avoids Cache memory issues)
  4. Add IS as a Clustered Service
  5. Add NS as a Clustered Service

Comments

Popular Posts