To resolve this problem, you must restart the Microsoft SQL Server services and the DTC services on both computers.
Note Make sure that you restart the DTC services on both computers before you restart the SQL Server services.
To do this, follow these steps.
Important Follow each step on both computers before you go to the next step.
- Use the SQL Service Manager to stop any SQL Server services that are running.
- Use the Services tool in Microsoft Management Console to stop the Distributed Transaction Coordinator services.
- Use the Services tool to start the Distributed Transaction Coordinator services that you stopped in step 2.
- Use the SQL Service Manager to start the SQL Server services that you stopped in step 1.