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
0
votes
1 answer

Is it required to start MSDTC service on database server along with web server? Also should it be running on mirroring server too?

My project supports nested transactions and thus we have MSDTC service running on web server as well as on database server. The project is working fine. However, we have database mirroring established over database server and thus whenever fail-over…
Mahesh Padekar
  • 49
  • 6
0
votes
1 answer

Does Distributed Transaction Escalation occur if one of the Databases is READ ONLY?

We are doing an import process from a source database to a destination database. We need to run these imports frequently in an automated fashion. The source is on a separate server than the destination. Both are MS SQL 2008. We access the…
caryden
  • 7,738
  • 3
  • 30
  • 31
0
votes
1 answer

Oracle cluster ODP.net Distributed Transaction Coordinator data loss

This is ASP.NET 4.0 application which is using Oracle cluster through ODP.net and Distributed Transaction Coordinator/MSDTC. In System.Transactions.TransactionScope transaction, it saves data in two different databases (db1 and db2). It commits…
user1663715
  • 396
  • 1
  • 4
  • 19
0
votes
1 answer

DTC issues using Oracle and .NET 4 - RM_COMMIT_DELIVERY_FAILED_DUE_TO_CONNECTION_DOWN

First a little intro to our setup: WCF based app with EF 4 context injected using Unity (no singleton) Oracle running on a seperate physical machine NServiceBus handling messages that access Oracle through the same context as above The problem we…
Bjorn Bailleul
  • 3,055
  • 1
  • 20
  • 25
0
votes
1 answer

Which MSDTC is the transaction manager?

Having a distributed transaction over 2 SQL Server databases, which MSDTC will be chosen to be the transaction manager?
bjnr
  • 3,353
  • 1
  • 18
  • 32
0
votes
2 answers

What is a transaction bridge in MSDTC?

When MSDTC starts up, it creates an event log entry that displays all the startup settings. One of them is "Transaction Bridge Installed". I assume this is similar to a JBoss Transaction Bridge. Google has suprisingly few search results, other than…
Pete
  • 6,585
  • 5
  • 43
  • 69
0
votes
0 answers

Distributed Transactions on SQL Server 2012

I am trying to execute a stored procedure on linked server B from inside a trigger on server A. When I do this I get the error: No transaction is active. and the transaction is aborded. I have already followed the answers provided here, but to no…
LuigiEdlCarno
  • 2,410
  • 2
  • 21
  • 37
0
votes
0 answers

Overcoming MS DTC Limitations when using Mirroring

An unforeseen requirement has hit our team. Our SQL Servers, 2008 R2, are using a mirroring setup on two databases. We supplied a WCF Data Service for clients to consume including the web development team. The other team found that they had so many…
jjhayter
  • 352
  • 4
  • 19
0
votes
1 answer

How do I use a TransactionScope with two databases when one is SQL Server CE?

I have two databases: dbGlobal is SQL Server 2008, and dbLocal is SQL Server 2008 CE. For business reasons, I need to keep some data local to a user while other data global to all users. In many cases, I'll have a table in dbLocal that has a…
user2023861
  • 8,030
  • 9
  • 57
  • 86
0
votes
1 answer

MS States remote proc trans option will be removed in Next version of SQL SERVER

I'm not sure whether it is right to ask it here... I searched the net for an answer, But in vain... So I just wanted to try my luck here. Here is the excerpt from Microsoft Website…
The King
  • 4,600
  • 3
  • 39
  • 58
0
votes
0 answers

Using two contexts in one Transaction and error with DTC

In one transation I use two different contexts: using (TransactionScope scope = new TransactionScope()) { using (Entities1 context = new Entities1()) { .... } using (Entities2 context2 = new Entities2()) { .... var tmp…
user2404459
  • 1
  • 1
0
votes
1 answer

Distributed Transcations, DTCPING, How to set NetBIOS

I'm the Microsoft Distributed Transaction Coordinator to write to two different databases on separate servers that are not on the same network. When I attempt to execute the code inside a C# TransactionScope, I get the following error:…
Adam Levitt
  • 10,316
  • 26
  • 84
  • 145
0
votes
1 answer

MSDTC (Distributed Transactions) support in MySQL

Does MySQL support MSDTC?
Kristoffer
  • 834
  • 6
  • 22
0
votes
1 answer

Dynamically created distributed queries in SQL Server 2008 on Windows 7

I am just doing some stat collection on multiple servers, and as a test I'm working with my machine (Machine A) and another machine (Machine B) on the local network. My Machine (A) is collecting all the information in the staging table from the…
Zielyn
  • 1,026
  • 6
  • 4
0
votes
1 answer

Is it possible to stop MassTransit Runtime Services from requiring DTC?

I'm getting started using MassTransit and need to use the RuntimeServices to manage subscriptions and timeouts. The environment I'm installing into is an externally facing network divided up in to segments using firewalls. Currently the application…
WooWaaBob
  • 3,397
  • 3
  • 23
  • 23
1 2 3
…
26
27