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.

2017-08-15_20-46-01

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

2017-08-15_20-46-59

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

2017-08-15_20-47-39