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, and is also available for Windows NT 4.0.
Questions tagged [msdtc]
35 questions
5
votes
1 answer
What is "tid" in a MSDTC trace?
I'm looking for some documentation on the content of a dtc trace file. Some columns is understandable like "pid" could be process id. But what is "tid". Guesswork would lead me to transaction id or thread id.
The reason for this question is that in…
Mikael Eriksson
- 153
- 4
4
votes
0 answers
Local DTC is missing on server 2008r2
I've recently had an issue where MSDTC was unable to start up.
The error in the command line when running net start msdtc indicated that there were configuration issues.
I went into the registry and set the configuration settings to the same values…
Reaces
- 5,547
- 4
- 36
- 46
4
votes
0 answers
MSDTC is unavailable, but only in one direction?
I have DTC enabled on 2 servers - a web server, and a database server. There are a few places in our web applications where we need to use DTC (via a TransactionScope) to manage transactions involving multiple databases. On our AD servers it is…
Beep beep
- 1,843
- 2
- 18
- 33
4
votes
2 answers
Why does SQL Server 2008 crashed on simple SQL queries?
I'm a developer and running a SQL Server 2008 SP1 instance (default instance) on my local machine (Windows 7 RC 32-Bit).
Sometimes when the program I'm developing sends a query to the SQL Server, the whole SQL Server crashes. The SQL queries are not…
Oliver Hanappi
- 143
- 4
4
votes
1 answer
Distributed Transaction failure with Windows Server 2008
I'm having a problem with a new server setup. Distributed Transactions started by the application server to the new server are failing, but they work fine with an existing database server. I need help determining the cause of the problem.
For…
Scott
- 213
- 3
- 13
4
votes
1 answer
SQL Server linked server: "Cannot start more transactions on this session."
i am trying to perform an INSERT operation against a linked server:
DBCC TRACEON (3604, 7300)
BEGIN TRANSACTION
INSERT INTO LIVE.Contoso.dbo.Events (EventGUID, EventDate, LoginGUID, UserGUID, EventType, Notes, TargetGUID)
VALUES…
Ian Boyd
- 5,131
- 14
- 57
- 79
4
votes
0 answers
Problems with DTC and IBM MQ
I've just run DTC Ping to try to find the cause of a MQ problem.
It says the following:
++++++++++++Validating Remote Computer Name++++++++++++
10-18, 10:30:31.508-->Start DTC connection test
Name Resolution:
…
jgauffin
- 139
- 1
- 13
3
votes
1 answer
Setting up network for MSDTC connections: How many open ports?
We have a web server (IIS) and a database server (MS SQL 2005) separated by an application proxy / firewall. We want to keep the number of open ports between the two machines at a minimum. Obviously port 1433 (or equivalent) is needed, however, we…
Peter K.
- 80
- 5
- 17
3
votes
1 answer
Does Sql Server Express supports MSDTC
I need MSDTC(Microsoft Distributed Transaction Coordinator) in one of my application. I am not sure whether it is available on Sql Server Express editions.
I googled on MSDN and haven't got clear answer on this. It seems with googling that it is…
Shantanu Gupta
- 219
- 1
- 8
2
votes
1 answer
Problem with Distributed Transactions between machines in different domains
We are tring to use an application that uses transactions.
The machine running the code is on a stand alone Windows 2003 Server machine.
The database server is a Windows 2003 Server with SQL Server 2005 on a domain machine on a different…
Shiraz Bhaiji
- 2,219
- 8
- 34
- 47
2
votes
1 answer
What is the difference between setting the DTC port range via Registry and dcomcnfg?
I am confused about setting the port range for DTC communication. What is the difference (functionally) by setting the ports via dcomcnfg as described in this NServiceBus Article versus configuring them through the registry as described in this…
Robin
- 23
- 5
2
votes
2 answers
why would adding a crossover private nic cause IP address resource fail?
2 node Win 2008 R2 quorum cluster
Configured 192.168.0.0/24 "public network"
Configured cluster MSDTC
Installed SQL 2008 R2 cluster instance
Manually failover groups - OK
Reboot server w/o failing over groups - failover OK
Pull public network cable…
AndyG DBA_ANDY
- 21
- 2
2
votes
2 answers
How to configure MSDTC on Windows Server 2008 R2?
I have a COM+ component on a different server, but when I made an update to one these components then it stopped working. How to configure MSDTC?
From the application log:
A caller has attempted to propagate a transaction to a remote system, but…
marko
- 179
- 1
- 3
- 10
2
votes
2 answers
Do MSDTC and disaster recovery go together?
Our application writes to multiple Sql Server databases within a distributed transaction. The Ops guys are saying that this messes up their disaster recovery plan because while the transactions on the live tables may commit at the same time, the log…
DevDelivery
1
vote
2 answers
Distributed Transaction Coordinator stops working properly after few hours
We noticed that DTC service stopped working properly. Log from ASP.NET application:
System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
at…
rotman
- 241
- 1
- 3
- 11