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

4
votes
2answers
354 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 ...
3
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
450 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 ...
2
votes
2answers
243 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 ...
2
votes
1answer
385 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 ...
2
votes
0answers
20 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 ...
2
votes
0answers
739 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
7k 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
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
758 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.
1
vote
1answer
938 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 ...
1
vote
0answers
39 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 ...
1
vote
0answers
191 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
339 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 ...
1
vote
0answers
613 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 ...
1
vote
1answer
447 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
108 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
363 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
0answers
204 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
vote
0answers
819 views

Weird Windows 2003 MSDTC and SQL 2005 issue

scenario: Windows 2003 sp2 x64 enterprise edition. SQL 2005 sp2 cu9 x64 Enterprise edition After restarting the resource groups on two node active-active cluster, 3 SQL 2005 instances start up fine. ...
0
votes
1answer
2k 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, ...
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 ...
0
votes
1answer
611 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 ...
0
votes
0answers
13 views

How does MS SQL Server authenticate MSDTC connections when using SSPI? [migrated]

I'm trying to get SSPI authentication to play well with two-phase transactions via MSDTC, using PostgreSQL with psqlODBC. I can't figure out how it can work securely - so I'm hoping someone can ...
0
votes
1answer
541 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
0answers
37 views

SQL DTC Failover Scenario

We had an interesting scenario in our clustered production environment last week. SQL 2008/R2 two boxes clustered on Win 2008/R2 in Active/Passive mode. On the active node A, the clustered MS/DTC ...
0
votes
1answer
176 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 ...
0
votes
1answer
191 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 ...
0
votes
2answers
211 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, ...
-1
votes
1answer
617 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 ...