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
15
votes
4 answers

TransactionScope - The underlying provider failed on EnlistTransaction. MSDTC being aborted

Our team have got a problem that manifests as: The underlying provider failed on EnlistTransaction; Cannot access a disposed object.Object name: 'Transaction'. which seemed to appear as soon as we began using TransactionScope to handle our…
m.edmondson
  • 30,382
  • 27
  • 123
  • 206
14
votes
7 answers

MVC 3 : The MSDTC transaction manager was unable to pull the transaction from the source

I am using MVC 3 with Entities, now I have used the below line of codes from my controller using (var scope = new TransactionScope()) { _myRepository.DeleteFM1(id); _myRepository.DeleteFM2(id, name); …
Yasser Shaikh
  • 46,934
  • 46
  • 204
  • 281
13
votes
2 answers

MSDTC - how many ports are needed

I have a considerably large application that uses MSDTC. How many ports should I open? Is there any way to determine it? EDIT: I know what ports I need to open, I don't know how many I need.
Migol
  • 8,161
  • 8
  • 47
  • 69
13
votes
2 answers

Trace why a transaction is escalated to DTC

Is there any way to determine precisely why a System.Transaction TrasactionScope is being escalated to the DTC? We are hitting a bump with one of our components that seem to escalate the transaction while all other components (which seem deceptively…
soren.enemaerke
  • 4,770
  • 5
  • 53
  • 80
13
votes
3 answers

BEGIN TRY/CATCH and MSDTC error

1/ The following code snippet show me the expected error: The INSERT statement conflicted with the FOREIGN KEY constraint FK_... SET XACT_ABORT ON; BEGIN TRANSACTION INSERT INTO linkedsrv1.db1.[dbo].tbl1 ([Col1], [Col2]) VALUES (1200, 0)…
user3104183
  • 408
  • 1
  • 9
  • 26
13
votes
1 answer

MSDTC and firewall

We are using MSDTC for SQL transactions. I am having issue with setting up firewall for MSDTC to work. The application and SQL are running on separate machine. Currently MSDTC is working if i turn off firewall on application server. I think there…
Balaji
  • 2,109
  • 5
  • 27
  • 34
13
votes
2 answers

Why does the SSIS Runtime fail to start the distributed transaction?

While creating an SSIS package for SQL Server 2008 i run into the following error: Error: The SSIS Runtime has failed to start the distributed transaction due to error 0x8004D01B "The Transaction Manager is not available.". The DTC …
Cros
  • 4,367
  • 9
  • 41
  • 47
12
votes
3 answers

How to use nested TransactionScopes against an Azure SQL Database

I'm currently trying to use nested transaction scopes for DB access against an Azure SQL Database. I'm using the following code (.Net 4.5.1, my code is async all the way down, it's ASP.Net MVC with EF6.1): public async Task Test() { // In my…
ken2k
  • 48,145
  • 10
  • 116
  • 176
12
votes
2 answers

How to fix Distributed Transaction Manager (MSDTC) has been disabled errors

We are using transaction scope features of ASP.NET to manage distributed transaction for that we need to enable distributed transaction via following link: The partner transaction manager has disabled its support for remote/network transactions Its…
Jalpesh Vadgama
  • 13,653
  • 19
  • 72
  • 94
11
votes
1 answer

MSDTC is only working in one direction

I'm trying to use TransactionScope for unit tests and I keep getting errors on our build server. After following several helpful SO answers and blogs, I installed DTCPing and ran it on both server1 & server2. When I run it in the reverse order it…
kelloti
  • 8,705
  • 5
  • 46
  • 82
11
votes
3 answers

Problems with MSDTC - remote transactions

We're in the process of moving our SQL Server to it's own machine, but I'm having issues getting transactions through MSDTC to work. Here is the error message ASP.Net is generating for me: The transaction manager has disabled its support for…
kastermester
  • 3,058
  • 6
  • 28
  • 44
10
votes
2 answers

Does TransactionScope Need DTC Service on?

From what I'm reading, in order to use TransactionScope in .NET, you need the Distributed Transaction Coordinator service in Windows to be running. I have that service turned off, and my app seems to be running the same and rolls back transactions…
SaltProgrammer
  • 1,045
  • 2
  • 13
  • 29
10
votes
2 answers

Distributed Transactions: .NET Framework vs .NET Core

I have the following code sample: static void Main(string[] args) { TransactionManager.DistributedTransactionStarted += (sender, eventArgs) => { Console.WriteLine("Promoted to distributed transaction!"); }; ​ const string…
chrisv
  • 563
  • 1
  • 6
  • 10
10
votes
1 answer

Reliable test for MSDTC promoting transactions to distributed?

How can I reliably check that MSDTC has promoted a transaction to a distributed transaction? This is when using TransactionScope in .net. Currently a co-worker is testing this by shutting down the coordinator on his machine - if an exception is…
Oded
  • 489,969
  • 99
  • 883
  • 1,009
10
votes
2 answers

SqlConnection and avoiding promotion to MSDTC

When we need to do database access in our application, we use the following patterns: For querying, we have a static factory class with a method CreateOpenConnection which does nothing more than new SqlConnection(myConnectionString) and calls…
JulianR
  • 16,213
  • 5
  • 55
  • 85
1
2
3
…
26 27