Article ID: 307802 - View products that this article applies to.
This article was previously published under Q307802
Under rare conditions, the following error message is returned to the client and logged to the Microsoft SQL Server error log:
Error: 8510, Severity: 20, State: 1
Enlist of MSDTC transaction failed: Result Code = 0x8004d00e..
Under the conditions that are described in this article, the logging of error 8510 is considered unnecessary. For details about the specific conditions, see the "More Information" section.
Beginning with SQL Server 2000 Service Pack 1 (SP1), error 8510 is not logged to the error log under the conditions that are described in this article. Instead, error 8510 is raised internally within SQL Server but is not sent to the client or logged in the error log. You still see error 8510 in SQL Profiler if you are capturing the Exception event.
A rare condition can occur when a server process ID (SPID) makes a call to the sp_reset_connection stored procedure. That SPID first obtains a reference to the Microsoft Distributed Transaction Coordinator (MSDTC) transaction. Later, it may try to enlist in the transaction. If the transaction has been committed or aborted between the time that the reference is obtained and the time that the attempt to enlist occurs, SQL Server raises error 8510.
The 8510 error message can occur when two SQL Server SPIDs are working on behalf of the same MSDTC transaction. One of the SPIDs is completing a successful abort or commit operation. The second SPID is trying to re-enlist or reset the connection state. The reset is generally associated with connection pooling operations. The second SPID incorrectly looks for the MSDTC transaction. Then, it encounters the 8510 error message when it can no longer locate the transaction by a GUID. It may not be able to locate the transaction because the transaction was aborted or committed successfully.
For this problem to occur, the following conditions must be true:
If error 8510 is logged to the error log, you should follow standard troubleshooting procedures.
Contact us for more help
Connect with Answer Desk for expert help.