Article ID: 230258 - View products that this article applies to.
This article was previously published under Q230258
This article has been archived. It is offered "as is" and will no longer be updated.
The Microsoft Distributed Transaction Coordinator (DTC) Setup program has been changed for SQL Server 6.5 Service Pack 5 and higher, including SQL Server 7.0.
With SQL Server 6.5 Service Pack 4 (SP4) releases and earlier, SQL Server Setup always installs Microsoft DTC 1.0 in the MSSQL\BINN directory, regardless of the current version of Microsoft DTC running on the system. No version checks are made before the DTC install, so any existing Microsoft DTC files are overwritten. Additionally, the setup of Service Pack 4 and earlier executes Msdtc.exe with the -Install option to initialize Microsoft DTC. If the system already has a newer version of Microsoft DTC installed the installation of SQL Server 6.5 Service Pack 4 and earlier may place the Microsoft DTC in an inconsistent state. For example, installing SQL Server 6.5 SP4 or lower on a system that currently has Microsoft Transaction Server 2.0 without installing the Windows NT Option Pack causes problems due to inconsistencies between the Microsoft DTC versions.
For additional information, please see the following article in the Microsoft Knowledge Base:
192680SQL Server 6.5 Service Pack 5 and higher and SQL Server 7.0 have been designed to correct this problem.
(http://support.microsoft.com/kb/192680/EN-US/ )PRB: Upgrading SQL Server 6.5 to the MTS 2.0 DTC Release
The setup of SQL Server 6.5 Service Pack 5 (SP5) and higher and SQL Server 7.0 include Microsoft DTC 3.0 components and the Microsoft DTC Setup program. Unlike the previous SQL Server releases, SQL Server 6.5 SP5 and higher and SQL Server 7.0 are version sensitive, ensuring that the latest version of Microsoft DTC Setup is on disk. These versions of SQL setup will first check to see if a newer version of the file Dtcsetup.exe exists on the system. If a newer version does exist on the system, SQL Setup will not copy the Microsoft DTC files to disk and will not run Microsoft DTC setup. However, if no newer version of the file is found, SQL Setup will copy the Microsoft DTC Setup program to the system directory (WINNT\SYSTEM32 for Windows NT or Windows 2000, Windows for Windows 95 or Windows 98) instead of the MSSQL\BINN directory. It then deletes the old version of the Microsoft DTC Setup program from the MSSQL\BINN directory and runs the new Microsoft DTC Setup. Note however, that a current bug in SQL Server 6.5 prevents this process from occurring correctly on Windows 2000 platforms.
Microsoft DTC Setup is Platform Specific
This key will contain the following values:
For Clustering Setup, after the Microsoft DTC setup is successful on the local computer, SQL Server Setup then loops through all the other nodes in the cluster and runs Microsoft DTC setup remotely. If any of them fail with a retryable error, SQL Server Setup will not proceed with the Microsoft DTC installation on the other nodes unless the retryable error is dealt with. Note that LocalSystem account is not valid for remote install. Microsoft DTC Setup requires you to run under context that has permissions on the first node.
Name Description --------------------------------------------------------------- CompletionComment (REG_SZ) An error description string. ErrorCode (REG_DWORD) 0 = Success 1 = No compatible Resource Groups were found. This is a Retryable error. 2 = Fresh Install on cluster but all Virtual Servers are owned by the other node in the cluster. Microsoft DTC setup requires that at least one Microsoft DTC compatible resource group be owned by the node on which DTC setup is run if and only if that node happens to be the first node in the cluster on which Microsoft DTC setup is run. (Retryable) 3 = Master Node Down - The node in the cluster on which Microsoft DTC setup was run first is down. This node must be running in order for Microsoft DTC setup to succeed. (Retryable) 4 = Miscellaneous (Non Retryable) ExitCode (REG_DWORD) 0 = Success 1 = Non Retryable Failure 2 = Installation Failed with Retryable Error. 3 = Installation Failed. Source (REG_DWORD) Name of the Microsoft DTC Setup phase that generated the Exit Status.
REFERENCESFor more information about Microsoft DTC Setup, please refer to the following articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/219264/EN-US/ )INF: Order of Installation for SQL 7.0 Clustering Setup
(http://support.microsoft.com/kb/197176/EN-US/ )INF: Readme.txt for SQL Server 6.5 Service Pack 5a
(http://support.microsoft.com/kb/197218/EN-US/ )INF: Stand Alone Distributed Transaction Coordinator Setup
Contact us for more help
Connect with Answer Desk for expert help.