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

Workflow Foundation and DTC transaction Rollback misbehavior

I'm testing the receive transaction scope in workflow foundation 4.5 and i think that there's something wrong with it! See when I roolback a transaction either by explicit roolback: using (TransactionScope s = new TransactionScope()) { using…
Leonardo
  • 10,737
  • 10
  • 62
  • 155
0
votes
2 answers

Commit and then Query within DTC using Entity Framework?

Quick (I think) question about how Entity Framework participates in a DTC Transaction. If I create two DbContexts within the same distributed transaction, will data I save in the first context be available to subsequent queries via the second…
Phil Sandler
  • 27,544
  • 21
  • 86
  • 147
0
votes
1 answer

Unable to enlist a distributed transaction after database restart

Hi I have problem with enlist to distributed transaction after database restart. My environment: Windows 7 x64 with SP1 Oracle Database 11g Express Edition ODP.NET 4.112.3.0 My program: const string connectionString = "Data…
Sławomir Rosiek
  • 4,038
  • 3
  • 25
  • 43
0
votes
1 answer

How to retrieve error code and message when distributed tx fails? (MS DTC)

We have got a stored procedure that starts a distributed transaction via a linked server with different MS SQL 2008 databases. We use SET XACT_ABORT ON; and also BEGIN TRY / CATCH blocks around the transaction to catch any errors and return…
spse
  • 284
  • 2
  • 11
0
votes
0 answers

Does an MSDTC transaction track/rollback file moves across network shares on different servers?

We have an application that uses MSDTC (Microsoft Distributed Transaction Coordinator) to wrap multiple calls to a database. In between these database calls, the application also moves files from one network share to another. Setting aside the…
Nate Sauber
  • 1,118
  • 2
  • 10
  • 26
0
votes
1 answer

Using transactions with EF4.1 and SQL 2012 - why is DTC required?

I've been doing a lot of reading on this one, and some of the documentation doesn't seem to relate to reality. Some of the potential causes would be appropriate here, however they're only related to 2008 or earlier. I define a transaction scope. I…
hitch
  • 899
  • 1
  • 11
  • 26
0
votes
2 answers

Is it possible to use transaction between two instances without enable DTC?

I have two instances of database located in two servers. I want to create an application to insert data into the first one and then update data on the second instance, if one of these process fail then I want to rollback all operations. The database…
Anonymous
  • 9,366
  • 22
  • 83
  • 133
0
votes
1 answer

Why ENLIST=TRUE is increase count of sessions of oracle for the max?

We are using MSDTC in WCF service. Configuration consist of 3 computers: 1. Server Oracle on Linux. 2. IIS with client of service WCF on server 2003. 3. IIS with server of service WCF and server Oracle on server 2003. If connection string has…
user1619561
  • 1
0
votes
1 answer

Why does System.Web.Security.Roles.RoleExists in combination with LocalDB source require MSDTC?

In a .NET 4.0 project, I'm experiencing that a call to System.Web.Security.Roles.RoleExists within a System.Transactions.TransactionScope fails due to MSDTC not being enabled on my development machine. The role manager's data source is LocalDB and…
aknuds1
  • 65,625
  • 67
  • 195
  • 317
0
votes
1 answer

InvalidOperation in NHibernate AbstractBatcher on DTC Transaction close

I'm working on an application that is multi-threaded and using NServiceBus and NHibernate with SQL Server 2008RC (using DTC). The process has one session factory. Each thread has it's own Session which is disposed of when the transaction is…
PBe
  • 11
  • 2
0
votes
1 answer

How to config msdtc remote coordinator host name using powershell?

I'm trying to config msdtc remote coordinator host name on 17 web servers using powershell which is part of our deployment script. But I couldn't figure out how. i'm able to do it manually though using comexp.msc The following is similar question…
Jake Chambers
  • 107
  • 10
0
votes
1 answer

SQL Server 2005 trigger to update remote server

I have created a trigger that updates an remote SQL Server 2005 database table. The code works if it is a manual query but will not work in a trigger because it tries to place it in a transaction and fails because of MSDTC. Our internal server has…
Luke Wilkinson
  • 439
  • 8
  • 17
-1
votes
1 answer

Distributed Transaction Coordinator

I am trying make a database transaction(inserting records) across multiple system. So, I decided to use System.Transaction Namespace in .net. I configured MSDTC on both system(But i dont know whether i configured correctly). My transaction has two…
Partha
  • 2,062
  • 6
  • 24
  • 31
-1
votes
1 answer

Windows DTC Security Risks?

I'm needing Windows DTC services enabled/configured to coordinate cross-server SQL transactions. However, the network admin refuses my request because I need the following configuration setting: I have scoured the web but unable to find…
mrtedweb
  • 783
  • 2
  • 9
  • 18
-1
votes
1 answer

link server SQL transaction scope not working

I am not able to use the connection within the transactionscope It is displaying the error MSDTC on "server" is unavailable.
sanuj dananjaya
  • 19
  • 1
  • 6
1 2 3
…
26
27