In my case, the service was stopped. solution: need to turn the MSDTC service on go to Services. (START > SETTINGS > CONTROL PANEL > ADMINISTRATIVE TOOLS > SERVICES) Find the service called ‘Distributed Transaction Coordinator‘ and RIGHT CLICK (on it and select) > Start. make this service to run Automatically for solving this issue … Read more
Found it, MSDTC on the remote server was a clone of the local server. From the Windows Application Events Log: Event Type: Error Event Source: MSDTC Event Category: CM Event ID: 4101 Date: 9/19/2011 Time: 1:32:59 PM User: N/A Computer: ASITESTSERVER Description: The local MS DTC detected that the MS DTC on ASICMSTEST has the … Read more
Use this for windows Server 2008 r2 and Windows Server 2012 R2 Click Start, click Run, type dcomcnfg and then click OK to open Component Services. In the console tree, click to expand Component Services, click to expand Computers, click to expand My Computer, click to expand Distributed Transaction Coordinator and then click Local DTC. … Read more
SQL Server 2008 can use multiple SQLConnections in one TransactionScope without escalating, provided the connections are not open at the same time, which would result in multiple “physical” TCP connections and thus require escalation. I see some of your developers have SQL Server 2005 and others have SQL Server 2008. Are you sure you have … Read more