MSDTC

Question

I am going to setup 2 node clustering. Do we really need MSDTC.

What is the use of MSDTC.

What happn if not configured MSDTC.

Answer 1

MSDTC allow for a transaction to be distributed over several database servers. Whether you need it or not, you have to ask the one who delivered your applications. "Do your app use MSDTC?"

---

Tibor Karaszi, SQL Server MVP (Web Blog)

Answer 2

I am going to setup 2 node clustering. Do we really need MSDTC.

What is the use of MSDTC.

What happn if not configured MSDTC.

If you are installing cluster having SQL Server version 2008 and above installing msdtc is not a must do thing. Please read this blog to know when you would need an msdtc

---

Cheers,

Shashank

Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

My TechNet Wiki Articles
MVP