Transaction over linked server causing time out
It seems Windows Firewall blocks DTC packages. To allow it to communicate through Windows Firewall, go to Control Panel > Windows Firewall > Allowed Apps and from list of apps, check Distributed Transaction Coordinator for both Private and Public networks.

If it doesn't works for you check out these solutions:


Unable to begin a distributed transaction
No transaction is active message when accessing Linked Server