SQL Server Error Msg 8566 – Unable to commit a prepared transaction from the Microsoft Distributed Transaction Coordinator (MS DTC). Server will restart the database and MS DTC recovery is expected to resolve any in-doubt transaction.

In this blog post, let’s learn about the error message “8566 – Unable to commit a prepared transaction from the Microsoft Distributed Transaction Coordinator (MS DTC). Server will restart the database and MS DTC recovery is expected to resolve any in-doubt transaction.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

8566 – Unable to commit a prepared transaction from the Microsoft Distributed Transaction Coordinator (MS DTC). Server will restart the database and MS DTC recovery is expected to resolve any in-doubt transaction.

Reason for the Error

To be update soon…

Solution

To be update soon…