I have implemented TransactionScope to execute queries from local computer to cloud SQL Server database in a VM. However, it throws the exception "Communication with the underlying transaction manager has failed" when there is more than one connection inside Transactionscope. It's possible to telnet from local computer to VM. Also, I have configured the following.
- Allow DTC in the allowed app list
- Checked MSDTC service is Started
- Network DTC Access
- Allow Inbound
- Allow Outbound
- Allow Remote Administrator
- Allow Remote Clients
- No Authentication Required
- Enable XA Transaction
- Enable SNA LU 6.2 Transaction