SQL Server could not register with Microsoft Distributed Transaction Coordinator (MS DTC

  • Hi Friends,

    I am getting this below error:

    SQL Server could not register with Microsoft Distributed Transaction Coordinator (MS DTC) as a resource manager for this transaction. The transaction may have been stopped by the client or the resource manager.

  • 1.Make sure the Distributed Transaction coodinator is running windows services (Start->Administrative tools->Services)

    2.Enable remote connection on MSDTC as below:

    Start->Administrative Tools->Component Services->Computer->Mycomputer->right click Mycomputer and select properties->goto MSDTC tab>security configuration->enablt network dtc access. here enable al the remote connections and click ok. The msdtc will be restarted and your query shoul work

    cheers

  • The account running SQL Server needs to have the 'Read Write' privilege on the MSDTC service.

    The Windows default is that Everyone has this privilege, but some places tie down this privilege with GPOs. If this is the case where you are, you will need to get the GPO changed.

    If security is tied down with GPOs, check the access rights to the Event Log service. The account running SQL 2005 Agent needs 'Read Write' privilege on this service in order to start.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply