Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Is it necessary to configure MSDTC as a clustered resource for SQL Server clustering to work?

April 26, 2017clustered clustering configure msdtc necessary Resource SQL Server

0

Posted

Is it necessary to configure MSDTC as a clustered resource for SQL Server clustering to work?

1 Answer

0

Posted

No. MSDTC is required only if you need the ability to perform distributed transactions on your cluster. If you intend to use linked servers or perform replication (snapshot/transactional with immediate/queued updating subscribers), MSDTC is required. For more information, see “Distributed Transactions architecture” in SQL Server 2000 Books Online.