Test MSDTC Connectivity Between Servers

Owned by Knowledge Assistant
Aug 25, 2023
1 min read





Description of Issue

Need to test MSDTC connectivity between app server(s) and database server(s) to determine if issue is firewall or configuration based.



Context

  • MSDTC

  • DTC

  • .NET



Cause

MSDTC connectivity and configuration between servers needs to be tested.



Resolution

  1. Connect to server you are testing from. Typically you will need to test the connection from the application server going to the database server

  2. Run PowerShell as administrator

  3. Run the script below, replacing xxx with the target server name

    1. Test-Dtc -LocalComputerName "$env:COMPUTERNAME" -RemoteComputerName "xxxx" -ResourceManagerPort 17100 -Verbose

    2. Ex: Test-Dtc -LocalComputerName "$env:COMPUTERNAME" -RemoteComputerName "tyler-db" -ResourceManagerPort 17100 -Verbose



Additional Information

The script output will say in plain text if configuration or firewall settings are causing connectivity between servers to fail.

The OleTx CID Is The Same, The CID should be unique to each computer