How to fix common MSDTC issues

On Identify server, we need to update it:

  • Ensure that the MSDTC is ready by opening Component Services, choosing Properties on Local DTC (it is placed under Component Services|Computers|MyComputer|Distributed Transaction Coordinator), clicking the Security tab, and making sure things look as shown below:

Issue-7-MSTDC-1

  • Access Control Panel, open Windows Firewall, and choose the setting, Allow an app or feature through Windows Firewall, to see if Distributed Transaction Coordinator is allowed or not.

Issue-7-MSTDC-2

On Database server, we need to handle:

  • Ensure that the MSDTC is ready by opening Component Services, choosing Properties on Local DTC (it is placed under Component Services|Computers|MyComputer|Distributed Transaction Coordinator), clicking the Security tab, and making sure things look as shown below:

Issue-7-MSTDC-3

  • Access Control Panel, open Windows Firewall, and choose the setting, Allow an app or feature through Windows Firewall, to see if Distributed Transaction Coordinator is allowed or not.

Issue-7-MSTDC-4

  • Ensure that port 5022, which is used for mirroring, is enabled on the database servers by checking the following things:
    • Go to Control Panel, open Windows Firewall, and then click Advanced Setting
    • On Inbound rules, create a new rule for Port:

Issue-7-MSTDC-5

  • On the Protocol and Ports page, select TCP and port: 5022.

Issue-7-MSTDC-6

  • On the Action page, select Allow the connection.

Issue-7-MSTDC-7

  • On the Profile page, select to apply the rule to: Domain, Private, Public.

Issue-7-MSTDC-8

  • On the Name page, input the name rule then click Finish

Issue-7-MSTDC-9