"MSDTC Is Unavailable" Error When a Stand-Alone Instance of SQL Server Is in a Cluster Environment (822473)
The information in this article applies to:
- Microsoft Windows 2000 Advanced Server
- Microsoft Windows 2000 Professional
- Microsoft Windows 2000 Server
SYMPTOMSBy default, when a stand-alone instance of Microsoft SQL Server exists in a cluster environment, the SQL Server-based instance is set to start automatically.
If the host node is rebooted, you may receive the following error message when you issue commands that are related to distributed transactions: MSDTC on server 'servername' is unavailable. CAUSEAfter the Distributed Transaction Coordinator (DTC) proxy has initialized itself to talk to a specific DTC service, the only way to
make any changes is to stop the process. In this situation, the stand-alone SQL Server-based service is started before the cluster SQL Server-based service. When the SQL Server-based service initializes the DTC proxy, the SQL Server-based service
starts and then connects to the local DTC service. This is not correct behavior in
a cluster environment.RESOLUTIONHow to Obtain the HotfixThis issue is fixed in the Microsoft Windows 2000 Post-Service Pack 4 (SP4) COM+ 1.0 Hotfix Package 27. For additional information, click the following article number to view the article in the Microsoft Knowledge Base: 822618 INFO: Availability of Windows 2000 Post-Service Pack 4 COM+ Hotfix Rollup Package 27 WORKAROUNDTo work around this problem, set the stand-alone instance of SQL Server on the cluster service to restart manually.STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section of this article.
Modification Type: | Minor | Last Reviewed: | 11/8/2004 |
---|
Keywords: | kbBug kbfix kbQFE kbWin2000preSP5fix KB822473 kbAudDeveloper |
---|
|