Article ID: 889706 - View products that this article applies to.
When you have a Microsoft SQL Server 2000 virtual server in a Microsoft Windows Server 2003 clustered environment, distributed transactions may not be completed successfully. When the distributed transaction is performed, you receive the following error message:
Additionally, from your Microsoft Transaction Server (MTS) application, you receive the following error message when you connect to SQL Server:
Server: Msg 8501, Level 16, State 3, Line 1 MSDTC on server 'VirtualServerName' is unavailable.
Note In these error messages, VirtualServerName is the SQL Server 2000 virtual server name.
Error: -2147168228 Microsoft ODBC SQL Server Driver [MSDTC] MSDTC on server 'VirtualServerName' is unavailable.
Sometimes, you may also receive the following error message:
Server: Msg 7391, Level 16, State 1, Procedure spStoredProcedure, Line 58
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction. [OLE/DB provider returned message: Connection failure] OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d01c].
This problem occurs when the following conditions are true:
A supported hotfix is now available from Microsoft. For more information about how to obtain this hotfix, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/821751/ )Availability of Windows Server 2003 COM+ 1.5 Rollup Package 1
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/301600/ )How to configure Microsoft Distributed Transaction Coordinator on a Windows Server 2003 cluster
(http://support.microsoft.com/kb/294209/ )How to rebuild or move MSDTC used with a SQL failover cluster
(http://support.microsoft.com/kb/817064/ )How to enable network DTC access in Windows Server 2003
Contact us for more help
Connect with Answer Desk for expert help.