Questions tagged [mstdc]

The Distributed Transaction Coordinator (MSDTC) service is a component of modern versions of Microsoft Windows that is responsible for coordinating transactions that span multiple resource managers, such as databases, message queues, and file systems. MSDTC is included in Windows 2000 and later operating systems.

7 questions
14
votes
1 answer

How do distributed transactions work (eg. MSDTC)?

I understand, in a fuzzy sort of way, how regular ACID transactions work. You perform some work on a database in such a way that the work is not confirmed until some kind of commit flag is set. The commit part is based on some underlying…
Martin
  • 5,945
  • 7
  • 50
  • 77
6
votes
2 answers

SUBINACL getting access denied

Im trying to get SUBINACL utility to just display information of the MSDTC service. Im typing subinacl /service mstdc and I get an error 5 access denied C:\temp>subinacl /service msdtc msdtc - OpenService Error : 5 Access is denied. Elapsed…
Praveen
  • 657
  • 3
  • 9
  • 23
2
votes
5 answers

Transactionscope not working when two remote sql connections

I am using Two SQL Server connection object in my C# console application project. I need to do this in single transaction So I used Transactionscope (Distributed Transaction) I am not able to use the connection within the transactionscope It is…
web dunia
  • 9,381
  • 18
  • 52
  • 64
2
votes
4 answers

MSDTC - Communication with the underlying transaction manager has failed (Firewall open, MSDTC network access on)

I'm having problems with my ASP.NET web forms system. It worked on our test server but now we are putting it live one of the servers is within a DMZ and the SQL server is outside of that (on our network still though - although a different subnet) I…
Andrew
  • 9,967
  • 10
  • 64
  • 103
1
vote
0 answers

DTC - How to know the end of transaction

When we use .net method ContextUtil.SetComplete according to MSDN: "the COM+ context will commit the current transaction, and the object is deactivated on method return". The problem with that I don't know how to add code after the end of…
Nati
  • 21
  • 1
1
vote
2 answers

Performance transaction scope against DB2 table

We are trying to track down the cause of a performance problem. We have a table with a single row that contains a primary key and a counter. Within a transaction we read the value of the counter, increment the value by one and save the new…
Shiraz Bhaiji
  • 64,065
  • 34
  • 143
  • 252
0
votes
1 answer

Transaction scope wcf and avoid unwanted Escalation to Distributed Transactions

i have problem with escalation distributed transactions in wcf application. My code looks something like this : LogRepository public void AddLog(ImportLogDbo log) { using (DbManager dbManager = new…
Mennion
  • 2,873
  • 3
  • 20
  • 34