| Event Id | 8510 |
| Source | MSSQLServer |
| Description | Enlist of MSDTC transaction failed: %hs. |
| Event Information | CAUSE: This message occurs when an attempt is made to enlist a new or existing Microsoft Distributed Transaction Coordinator (MS DTC) transaction and that attempt fails. The cause of the failure to enlist varies. The state of the error, the specific result code returned with the error, as well as any other errors that occurred around the same time can help to determine why the enlistment failed in your environment. The failure to enlist is often a sign of a communications problem such as failed name resolution. It can also be the result of the way the calling application is coded or a result of blocking or performance issues on the SQL Server side. Under certain very specific conditions, when a second server process ID (SPID) attempts a new enlistment or makes a call to the sp_reset_connection stored procedure while the Microsoft Distributed Transaction Coordinator (MS DTC) transaction is being successfully interrupted or committed, the second SPID encounters a changing MS DTC transaction and generates the 8510 error message. The 8510 error message is considered unnecessary in these circumstances because the state of the transaction is already resolved before the error message occurs. RESOLUTIION: 1. Check that the MS DTC is started on both machines involved in the MS DTC transaction. If the MS DTC service is clustered, verify that it is online in Cluster Administrator. Review the event logs for the servers involved in the MS DTC transaction to see if there are other errors at the same time as this message. If there are other errors, troubleshoot them first, because this error is often a side effect of other errors. 2. By default, network MS DTC access is disabled on Windows Server 2003. If any computer involved is running Windows 2003, verify that MS DTC has been enabled. 3. Verify that RPC communications between the servers involved is working correctly. 4. Reboot the servers involved in the MS DTC transaction to f |
| Reference Links | Microsoft product: SQL Server Version: 2000.80.760.0 Event Source: MSSQLServer Event ID: 8510 |
Catch threats immediately
We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.