BUG: MS DTC Is Removed If SQL Server Registry Rebuild Is Run

ID: Q192707

The information in this article applies to:

Microsoft SQL Server version 6.5

BUG #: 18023 (SQLBUG_65)

SYMPTOMS

If you run a registry rebuild while the Microsoft Distributed Transaction Coordinator (MS DTC) service is running, the MS DTC service will be removed or marked for deletion. While running registry rebuild, you may receive the following message:

Failed to change the configuration of the MSDTC Service

WORKAROUND

To avoid removing the MS DTC service, make sure that the service is stopped before you run the registry rebuild. If you have removed the MS DTC service, running registry rebuild again adds MS DTC as a service. For more information, including the syntax of the registry rebuild command, see the following article in the Microsoft Knowledge Base:

Q157805 : BUG: RegistryRebuild Option of Setup Is Not Documented

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.5.

MORE INFORMATION

The MS DTC service may immediately be removed as a Windows NT service, or may still be listed as a running service. If you attempt a distributed transaction, the BEGIN DISTRIBUTED TRANSACTION statement will fail with the following error:

"DTC on server <sever_name> is unavailable."

Another symptom is that MS DTC may not be listed in SQL Enterprise Manager. Also, you may be able to stop the MS DTC service but upon restarting the service through Enterprise Manager, you may receive the following message:

An error 1072 - (The specified service has been marked for deletion)
occurred while performing this service operation on the MSDTC service.

Additional query words: dist tran

Keywords : SSrvInst kbbug6.50
Version : WINNT:6.5
Platform : winnt
Issue type : kbbug