[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 MS DTC was unable to start
 

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

Microsoft Distributed Transaction Coordinator (MS DTC) was unable to start.


Applies to: Microsoft SQL Server 2005 Enterprise Edition, Windows Server 2003 Enterprise Edition.
 


Error Message.


The following errors were logged in the Application Log while installing a SQL Server 2005 Cluster in a virtual server:

Event Type: Warning
Event Source: MSDTC Client
Event Category: Cluster
Event ID: 4148
Date: 7/7/2008
Time: 3:22:51 PM
User: N/A
Computer: NODE2
Description:
The MS DTC service was started before the cluster service on this cluster node. This service will now be stopped. If MSDTC has been configured to run on a cluster, the MS DTC resource will be brought online by the cluster service when it starts. Error Specifics: d:\nt\com\complus\dtc\shared\mtxclu\mtxclusetuphelper.cpp:932, Pid: 1080, CmdLine: "C:\WINDOWS\cluster\resrcmon.exe" -e 1280 -m 944 -p 4092






Event Type: Error
Event Source: COM+
Event Category: (98)
Event ID: 4691
Date: 7/21/2008
Time: 4:08:50 PM
User: N/A
Computer: NODE1
Description:
The run-time environment was unable to initialize for transactions required to support transactional components. Make sure that MS-DTC is running. (DtcGetTransactionManagerEx(): hr = 0x8004d01b)






Event Type: Error
Event Source: MSDTC
Event Category: Cluster
Event ID: 4384
Date: 7/21/2008
Time: 4:09:45 PM
User: N/A
Computer: NODE1
Description:
MS DTC was unable to start because the installation was not configured to run on a cluster. Please create a MS DTC resource through the cluster administrator. Error Specifics: d:\nt\com\complus\dtc\shared\mtxclu\mtxclusetuphelper.cpp:534, Pid: 4840, CmdLine: C:\WINDOWS\system32\msdtc.exe

 




Cause.

You are trying to set up a SQL Server cluster, but got the errors shown above while running SQL Server 2005 setup, because you forgot to create the MS DTC resource.


Solution.


Before using Cluster Administrator, please enable network Distributed Transaction Coordinator (DTC) access in Windows Server 2003 on all nodes, and then restart each node. Please visit the following link for instructions on how to do it.

http://support.microsoft.com/kb/817064

Then, create the Microsoft Distributed Transaction Coordinator resource. Please visit the following link for instructions on how to do it on Windows Server 2003:

http://support.microsoft.com/kb/301600



 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.