How to support MSDTC service

The Microsoft Distributed Transaction Coordinator (MS DTC) is a transaction manager that allows client applications to include several different sources of data in one transaction. MS DTC coordinates committing the distributed transaction across all the servers enlisted in the transaction.

As MSDTC Service is a very resource intensive and security comprehensive service on the SQL server, it can be supported only for semi dedicated users.