Is MSDTC essential for SQL server 2008R2 failover cluster installation

• Ryan007

  SSCrazy Eights

  Points: 8275

  More actions

  October 4, 2011 at 2:40 am

  #390535

  Is is essential to cluster the MSDTC resource before clustering SQL resource? If not clustered what are the disadvantages?

  Ryan
  //All our dreams can come true, if we have the courage to pursue them//

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  October 4, 2011 at 3:56 am

  #1390038

  No, it's not mandatory. You can have a cluster without a MSDTC resource.

  However, I would recommend it. You will find the reasons here: http://technet.microsoft.com/en-us/library/cc730992(WS.10).aspx?ppud=4

  -- Gianluca Sartori