Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [msdtc]

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.

35 questions
1
vote
0 answers

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 defined, but there will be at least 3 of them. I'm…
Massimo
  • 68,714
  • 56
  • 196
  • 319
1
vote
0 answers

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 tried the fix found on this MSDN blog. However, none…
Russ960
  • 233
  • 5
  • 13
1
vote
3 answers

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. If it is configured on cluster please run like…
Cute
  • 130
  • 1
  • 7
1
vote
1 answer

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 storage available. The storage node in the failover…
Jeremy
  • 903
  • 2
  • 9
  • 19
1
vote
0 answers

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 (running on Windows 2003 latest service packs). The…
WOPR
  • 147
  • 8
1
vote
1 answer

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 recently had an application upgrade where the…
Baz Duncan
  • 11
  • 1
1
vote
1 answer

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.
aarsh thakur
1
vote
1 answer

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 drive. How can we see if the MSDTC is actually in…
NobbySQl
  • 11
  • 1
1
vote
1 answer

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 ++++++++++++++++++++++++++++++++++++++++++++++ RPC server is…
JimmyP
  • 111
  • 1
  • 3
0
votes
2 answers

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, tower, butterfly flapping it's wings - the telco is…
Robert MacLean
  • 2,186
  • 5
  • 28
  • 44
0
votes
1 answer

Should I continue to use MSDTC in my new virtual environment for MSSQL?

In the past I have used a two node cluster setup. All the services (SQL, File Server, App Server, DTC) were passed back and forth within the cluster as normal. Now I take a different approach. I like to build my 2 node cluster and ONLY install the…
Arvo Bowen
  • 795
  • 5
  • 15
  • 33
0
votes
1 answer

XA transaction timeouts with SQL Server, MSDTC, and WebSphere

I have a Java/WebSphere application that is doing XA transactions with a SQL Server 2008 instance. In some environments, everything works as expected. In two of our environments, transactions will intermittently fail. Some info about the…
Jason B
  • 101
  • 3
0
votes
1 answer

The MSDTC transaction manager was unable to push the transaction to the destination transaction manager due to communication problems

I have a BizTalk server and a SQL server which BizTalk sends messages via WCF-SQL to. The BizTalk server has been calling to this server for over a year with no problems. I came in this morning any suddenly it can't (it was working on Friday). The…
Bensonius
  • 111
  • 1
  • 6
0
votes
1 answer

Oracle 11g MTS install fails with error: OUI - 10150: Error: A runtime exception occurred while setting s_dlgCfgNamingLabelSIDnull

Is there a workaround in the Oracle 11g Universal Installer for the following error? OUI - 10150: Error: A runtime exception occurred while setting s_dlgCfgNamingLabelSIDnull in component oracle Database 11g 11.2.0.1.0. installation cannot continue…
Thomas Bratt
  • 355
  • 2
  • 6
  • 16
0
votes
1 answer

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 issues with enabling it, but does SF know of any…
AWC
  • 101
  • 2
1
2
3