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 ...
1
vote
0answers
109 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
145 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
302 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
435 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
121 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
1answer
4k 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 ...
0
votes
1answer
282 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
85 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
299 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
661 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
827 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
149 views
What is the linux equivalent of MSDTC?
Windows has MSDTC to coordinate transactions across different resources. What is the equivalent technology in Linux?
0
votes
1answer
545 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 ...
3
votes
1answer
3k 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
197 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
193 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
343 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
502 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
294 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
1answer
726 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. ...
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
595 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.
