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
2
answers
582
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
1
answer
425
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 defined,...
0
votes
1
answer
4k
views
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 ...
1
vote
2
answers
12k
views
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 ...
4
votes
1
answer
23k
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
0
answers
323
views
How can I connect to the SQL database in the cloud via MSDTC?
Objective:
I am continuing the development of a legacy Windows Forms application by developing locally on my laptop. The app relies on MSDTC to connect to a SQL database. I want to host the SQL ...
4
votes
0
answers
588
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
...
0
votes
1
answer
7k
views
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 ...
2
votes
1
answer
679
views
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 ...
0
votes
1
answer
269
views
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 ...
0
votes
1
answer
2k
views
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 ...
4
votes
0
answers
2k
views
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 ...
2
votes
2
answers
1k
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 ...
4
votes
1
answer
10k
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 ...
2
votes
2
answers
17k
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 ...
5
votes
1
answer
344
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
0
answers
1k
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 ...
4
votes
0
answers
1k
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 ...
1
vote
1
answer
5k
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
votes
1
answer
2k
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 ...
0
votes
1
answer
10k
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 ...
1
vote
1
answer
757
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
0
answers
2k
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
1
answer
525
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
1
answer
201
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 ...
3
votes
1
answer
2k
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 ...
0
votes
2
answers
2k
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 ...
4
votes
2
answers
685
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
3
answers
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
1
answer
2k
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.
2
votes
2
answers
504
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
1
answer
770
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
2
answers
234
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, ...
0
votes
1
answer
2k
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 ...
3
votes
1
answer
6k
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 ...