Windows error 0x8004D02B, -2147168213

The MSDTC transaction manager was unable to pull the transaction from the source transaction manager due to communication problems

I have hosted my Webapp on server 1 and my database on server 2 But i m getting following error "Communication with the underlying transaction manager has failed." I googled and found a post which mentioned that it is the issue of DTC(Distributed Transaction) I enabled DTC on server2(DB server) [...] read more

c# EntityFramework: TransactionScope over two different databases on same server with DTC

I have basicly the same Situation as here described here Multiple databases(datacontext) on same server without MS DTC like: using (var transaction = new TransactionScope()) { using (var entities = new ContextA()) { // do smth. here } using (var entities = new ContextB()) { // do smth. there } [...] read more

Use a SqlConnection inside an Entity Framework transaction

I have an EF6 project that uses some legacy library (I can't modify this library). The code is like these in my project: Using scope As New TransactionScope() //Many DAOs calls that work just nice //The call to the legacy library that fails End Using The code is like these [...] read more

Getting MSDTC working across two EC2 instances

I have two EC2 instances, one running websites in IIS and the other hosting a SQL-Server instance. The website(s) are communicating fine for this server, pulling data out of the database without issue. However, when I go to write a suite of data, I am using DTC which is giving [...] read more

Nested Transactions - MSDTC

I am having an issue setting up transactions in my application. When I perform a light weight transaction it works: using (TransactionScope tx = new TransactionScope()) { // Connect to Server 1 in a transaction tx.Complete() } When I do a nested transaction, it fails: using (TransactionScope tx = new [...] read more

The MSDTC transaction manager was unable to pull the transaction from the source transaction manager

> System.Runtime.InteropServices.COMException: The MSDTC transaction manager was > unable to pull the transaction from the source transaction manager due to > communication problems. Possible causes are: a firewall is present and it > doesn't have an exception for the MSDTC process, the two machines cannot find > each other by [...] read more

SQL Server 2019 Linux MSDTC (Centos)

Hello I have a centos server with SQL Server 2019 , but we are trying to connect a c# app in a windows server 2008 and 2019 and we have this problem: > "The MSDTC transaction manager was unable to pull the transaction from the > source transaction manager due [...] read more

Exception when trying to setup database connection

I am trying to connect with database like var ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["connStringName"].ConnectionString; DbCommand dbCommand = db.GetStoredProcCommand("CorrectProcedureName"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { ... } When trying the exception is thrown with message: > The MSDTC transaction manager was unable to pull the transaction from the > source transaction manager due [...] read more

Entity Framework and Distributed Transaction Coordinator

I'm at my wits end trying to figure out why my transaction scope is giving me the following error: > "An exception occurred while initializing the database. See the InnerException > for details." > > --> "The underlying provider failed on Open." > > --> "Communication with the underlying transaction [...] read more

EF + Multiple transaction, Multiple Context

I have been trying everything to make this situation working, but unable so far * Entity Framework * XUnit (testing library) * 2 DbContext (2 differents databases, 2 connections strings) Situation: Run integration test with AutoRollBack feature (The AutoRollback feature manily wrap the code in a Parent transaction which is [...] read more

The MSDTC transaction manager was unable to pull the transaction from the source transaction manager

I have the following code that uses transactionScope using (TransactionScope scope = new TransactionScope()) { MamConfiguration oldConfiguration; int oldTestId; using (mamdbEntities = new MaMDBEntities()) { oldConfiguration = GetOldTestId(item.TestID); if (oldConfiguration == null) { ... ConvertToEfAndSave(item, oldTestId, oldConfiguration.CreatedDate); if(!item.UserMessage.IsErrorOccur) { scope.Complete(); } } The transaction fails with the following error: 17 [...] read more

MSDTC and Multiple EF ObjectContexts to separate SQL Server databases

I am having an issue with using TransactionScope that has has two Entity Framework ObjectContexts initialized in it, one for database X and one for database Y on the same server. The first context "cersCtx" creates a new "Contact" object. The second context "coreCtx" attempts to find an Account. On [...] read more

How to implement single transaction in Entity Framework 5 with both context SQL DB and DB2

I am trying to implement both DbContext (SQLDBContext & DB2Context) in single transaction but every time facing an issue related to DB2. It works fine with SQL but throws error when trying to access DB2. The exception is : > Error in DB2Entities getter.Communication with the underlying transaction > manager [...] read more

Underlaying Connection Issue while using TransactionScope

I am facing following error when opening multiple SqlConnection in my Application. I had configured the DTC, Firewall. But the same code is working fine in Miscosoft Enterprise Library. When i am manually trying to open the connection facing following error. "The MSDTC transaction manager was unable to pull the [...] read more

NServiceBus and MSDTC across domains?

So I'm trying to use NServiceBus and everything goes fine until my application tries to write data to the database via EF6, where I consistently get this exception: > 2016-11-18 13:35:28.340 INFO NServiceBus.RecoverabilityExecutor Immediate > Retry is going to retry message '28392aef-de00-4162-8cca-a6c200c0e68e' because > of an exception: System.Data.Entity.Core.EntityException: The underlying [...] read more

MSDTC and COM+ with Oracle database on Unix based server error out

I am getting following error when COM+ object with required transaction try to communicate with Oracle database. "Following is the error text…. Communication with the underlying transaction manager has failed. Inner Exception: The MSDTC transaction manager was unable to pull the transaction from the source transaction manager due to communication [...] read more

Windows 7 - Enable Network DTC Access

I have a Visual Studio 2010 Windows Forms application in which I start a transaction using the TransactionScope class. I then Receive a message from a Sql Server Broker Services message queue, which works fine. I next try to call a stored procedure from the same database with a call [...] read more