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 ...

learn more… | top users | synonyms

0
votes
0answers
19 views

Outgoing connection fails on clustered Windows Server 2008 R2

I have a problem with outgoing connection on clustered Windows Server 2008 R2. I have two servers in the cluster, the problem came in the fact that the servers has stopped working with the domain. In ...
3
votes
1answer
41 views

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 ...
1
vote
0answers
36 views

How many MSDTC clustered services (if any) are needed for a multiple-instance SQL Server 2012 cluster?

I'm creating a new SQL Server 2012 cluster, running on 2 physical nodes (the O.S. is Windows Server 2012 R2); the cluster will host multiple SQL Server instances; the exact number is yet to be ...
1
vote
0answers
139 views

MSDTC Errors: QueryInterface failed for “ITransactionDispenser”: 0x8004d01c(XACT_E_CONNECTION_DOWN)

I’m having some issues with a server where MSDTC is not working properly. This started happening about two days ago. I’ve tried a number of different things including restarting the VM and I’ve ...
2
votes
0answers
132 views

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

Windows Server 2008 R2 cluster, MSDTC issue

We recently installed MS Windows Server 2008 R2 EE on two physical IBM System x3550 M4 server and this cluster hosts Biztalk resources on it. MSDTC was configured prior to Biztalk resource were added ...
0
votes
1answer
411 views

BizTalk/MQ - DCOM was unable to communicate with the computer xxx using any of the configured protocols

I've read the other questions on this same error, but don't see a close match to this scenario. We got 18 of these last night between 12:17:13 and 12:39:37 on Win 2008/R2. It caused us to lose ...
2
votes
0answers
1k views

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 ...
1
vote
1answer
3k views

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, ...
1
vote
0answers
224 views

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 ...
1
vote
1answer
415 views

Clustering MSDTC on windows Server 2008 R2 returns “No storage Available”

I've set up a failover cluster, with SQL Server 2008r2, and it is running fine. I want to cluster MSDTC as well, but when I go through the high availability wizard, it tells me that there is no ...
2
votes
2answers
552 views

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 ...
1
vote
0answers
696 views

SQL Server 2012 - Linked Server to SQL Server 2000

I'm trying to use the SQLNCLI 10 driver to set up a Linked Server to a legacy SQL Server 2000 instance on our network. I understand you cannot use Version 11 as it doesn't support SQL Server 2000 ...
0
votes
1answer
219 views

MSDTC - COMException

We currently have 4 load balanced web servers connecting to a SQL 2005 database server. On the web servers is IIS 6 which has our Dot Net web services installed and Dot Net COM+ components also in Dot ...
1
vote
1answer
8k views

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 ...
1
vote
1answer
538 views

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 ...
1
vote
1answer
112 views

Failed to Attach DB on replicated SAN

We currently have a clustered SQL Server 2005 which has replicated SAN disks for our DR solution, to test DR we break the SAN synch and then attach the various DB's on the DR server. Our web servers ...
1
vote
1answer
396 views

SQL 2005 Cluster - How to move MSDTC

We currently have a 2 node (Win2003) SQL 2005 Cluster running 2 instances. We need to move all drives to a new SAN but are pondering over how to move the DTC that is currently 'logging' te Quorum ...
1
vote
1answer
1k views

Troubleshooting DTCPing Errors

So I am running DTC ping between 2 machines on our network and am getting the following error ++++++++++++++++++++++++++++++++++++++++++++++ DTCping 1.9 Report for WEB2 ...
0
votes
2answers
1k views

Clustered MSDTC - No transaction is active

Hi I Currently have two clusters (W2K8R2) with SQL 2K8R2, both with MSDTC cluster service enabled. I've configured the MSDTC with all checkboxes, and Incoming Caller Authentication Required and NT ...
1
vote
0answers
238 views

What is the linux equivalent of MSDTC?

Windows has MSDTC to coordinate transactions across different resources. What is the equivalent technology in Linux?
-1
votes
1answer
656 views

MSDTC Port 135 open bi-directionally

I have two servers, a web application server and an SQL Server database running on its own server. I have a firewall between these two servers. Do I have to open port 135 on both the SQL Server and ...
4
votes
1answer
4k views

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 ...
2
votes
2answers
253 views

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 ...
0
votes
2answers
214 views

3g modem dialup prevented by MSDTC corruption

We have ~50 machines which connect via a 3G modem from Option (either the Globesurfer Icon, Icon 401 or Icon 7.2) to the network, for some reason from the telco they will be dropped (signal issue, ...
2
votes
1answer
414 views

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

Security risk of enabling MSDTC

MSDTC is disabled by default (windows 2003 - onwards) and I want to have it enabled for an application I'm developing that requires distributed transactions. I don't believe there are any security ...
4
votes
2answers
385 views

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 ...
1
vote
1answer
3k views

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 ...
1
vote
3answers
2k views

How to install sqlserver2008 failover cluster on windows2003 server?

Can any one give me the procedure to create a failover cluster on windows2003??? Any links would also be helpful..... I got warning messages on MSDTC such that MSDTC is not running on local machine. ...
1
vote
1answer
892 views

Distributed transaction aborted by MSDTC

How to resolve the error 8522 in SQL Server 2005? I'm getting this error while I'm loading data from the remote server.