Stack Overflow
Stack Overflow

Questions tagged [msdtc]

MSDTC is an acronym for Microsoft Distributed Transaction Coordinator.

MSDTC is an acronym for Microsoft Distributed Transaction Coordinator. As its name implies, MSDTC provides transaction coordination between multiple resources. e.g. databases, message queues, etc.

Frequent issues are around network configuration (e.g. firewall ports and RPC ports) as well as DTC failures around unwanted transaction promotion.

Resources

Distributed Transaction Coordinator(MSDTC) and Transaction FAQ

405 questions
292
votes
7 answers

TransactionScope automatically escalating to MSDTC on some machines?

In our project we're using TransactionScope's to ensure our data access layer performs it's actions in a transaction. We're aiming to not require the MSDTC service to be enabled on our end-user's machines. Trouble is, on half of our developers…
Yoopergeek
  • 5,592
  • 3
  • 24
  • 29
115
votes
7 answers

How do I enable MSDTC on SQL Server?

Is this even a valid question? I have a .NET Windows app that is using MSTDC and it is throwing an exception: System.Transactions.TransactionManagerCommunicationException: Network access for Distributed Transaction Manager (MSDTC) has been…
Dan
  • 29,100
  • 43
  • 148
  • 207
105
votes
11 answers

Unable to begin a distributed transaction

I'm trying to run SQL against a linked server, but I get the errors below : BEGIN DISTRIBUTED TRANSACTION SELECT TOP 1 * FROM Sessions OLE DB provider "SQLNCLI" for linked server "ASILIVE" returned message "No transaction is active.". Msg 7391,…
Ian Boyd
  • 246,734
  • 253
  • 869
  • 1,219
58
votes
9 answers

MSDTC on server 'server is unavailable'

I get this weird error on SQL Server. And I cannot find solution in older posts. I have this procedure: create proc _upJM_SyncAll_test as begin DECLARE @SQLString nvarchar(max) set @SQLString = N' DELETE FROM OPENQUERY([LOCAL_MYSQL],''SELECT…
Kiki
  • 760
  • 1
  • 7
  • 17
28
votes
4 answers

MSDTC - Communication with the underlying transaction manager has failed

I am getting error: communication with the underlying transaction manager has failed when I am trying to run my application from visual studio 2010. I have search on google for this problem, I have tried all possible solutions to resolve this…
M005
  • 824
  • 1
  • 9
  • 25
26
votes
8 answers

Where do I get tracefmt.exe? And how do I read my MSDTC traces?

I followed the KB article from MS in order to turn on MSDTC trace. Unfortunately it was hard to follow, since it doesn't assume a very reasonable and obvious expectation of the reader, specifically "how do I read this binary log file?" I read this…
Adam Ritenauer
  • 3,151
  • 4
  • 33
  • 40
24
votes
4 answers

Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction

Just curious if anyone else has got this particular error and know how to solve it? The scenario is as follow... We have an ASP.NET web application using Enterprise Library running on Windows Server 2008 IIS farm connecting to a SQL Server 2008…
Jimmy Chandra
  • 6,472
  • 4
  • 26
  • 38
22
votes
5 answers

Any real-world, enterprise-grade experience with Transactional NTFS (TxF)?

Background: I am aware of this SO question about Transactional NTFS (TxF) and this article describing how to use it, but I am looking for real-world experience with a reasonably high-volume enterprise system where lots of blob data (say documents…
Jerry Bullard
  • 6,116
  • 18
  • 27
21
votes
2 answers

Exception "The operation is not valid for the state of the transaction" using TransactionScope

We have a web service on server #1 and a database on server #2. Web service uses transaction scope to produce distributed transaction. Everything is correct. And we have another database on server #3. We had some problems with this server and we…
Mykhail Galushko
  • 515
  • 2
  • 5
  • 14
20
votes
7 answers

The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server was unable to begin a distributed transaction

I'm trying to run a distributed transaction from my machine (SQL Server 2012) to a client server (SQL Server 2008). I'm trying to run: begin distributed transaction select * from [172.01.01.01].master.dbo.sysprocesses Commit Transaction and I…
Cameron Castillo
  • 2,712
  • 10
  • 47
  • 77
20
votes
1 answer

Connection pool corrupted by nested ADO.NET transactions (with MSDTC)

I can't find answer anywhere. I will show simple code fragment which presents how to easily corrupt connection pool. Connection pool corruption means that every new connection open try will fail. To experience the problem we need: to be in…
owerkop
  • 281
  • 3
  • 6
19
votes
3 answers

How to run two Entity Framework Contexts inside TransactionScope without MSDTC?

This problem is not readily reproducible in a simple example here but was wondering if anyone has any experience and tips, here is the issue: using Entity Framework have many points in application where (1) data is written to some entity table…
Edward Tanguay
  • 189,012
  • 314
  • 712
  • 1,047
17
votes
7 answers

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…
MARKAND Bhatt
  • 2,428
  • 10
  • 47
  • 80
17
votes
2 answers

Is Active Directory transaction-aware?

Simple question but I can't find the answer anywhere: is Active Directory transaction-aware? In other words, will the following change be rolled back (since I didn't call scope.Complete()): using (var scope = new TransactionScope()) { …
Ronald Wildenberg
  • 31,634
  • 14
  • 90
  • 133
16
votes
3 answers

EF: How do I call SaveChanges twice inside a transaction?

Using Entity Framework (code first in my case), I have an operation that requires me to call SaveChanges to update one object in the DB, and then SaveChanges again to update another object. (I need the first SaveChanges to resolve an issue where EF…
Gary McGill
  • 26,400
  • 25
  • 118
  • 202
1
2 3
…
26 27