EnlistDistributed Transaction Error - An event was unable to invoke any of the subscribers

From: Chris Dawson (mrchedda_at_gmail.com)
Date: 09/22/04


Date: 22 Sep 2004 11:45:41 -0700

Just applied SP1 for the v1.1 of the .NET Framework, and we're running
into an error while trying to manually enlist SqlConnection in a
Distributed Transaction (EnlistDistributedTransaction method). We're
receiveing the following error message:

System.Runtime.InteropServices.COMException

"An event was unable to invoke any of the subscribers"

Server stack trace: at
System.Runtime.InteropServices.UCOMIConnectionPoint.Advise(Object
pUnkSink, Int32& pdwCookie)
    at System.Data.SqlClient.ConnectionPool.PutConnectionManualEnlisted(SqlInternalConnection
con)
    at System.Data.SqlClient.ConnectionPool.PutDeactivatedConnection(SqlInternalConnection
con)
    at System.Data.SqlClient.SqlConnection.Close()
    at System.Data.SqlClient.SqlConnection.Dispose(Boolean disposing)
    at System.ComponentModel.Component.Dispose()

The code is running on a Windows 2000 Server, with Service Pack 4
installed. I've only noticed one other post about this, but it was in
regards to using the ServiceDomain class on a Windows 2000/XP box.
We're not utilizing the ServiceDomain class nor are we running on
Windows 2003.

Any help would be greatly appreciated.

- Chris