Article ID: 192707
Article Last Modified on 10/3/2003
APPLIES TO
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q192707
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:
157805 : 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:
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:
Additional query words: dist tran
Keywords: kbbug kbnofix KB192707