locked
Error Communicating with SQL Server on Azure RRS feed

  • Question

  • Hi,

    I have a BizTalk 2010 application on-premise, trying to communicate with a SQL Server on Azure.

    We use WCF-Custom, with SQL binding to communicate. If we disable ambient transaction at the send port, we are able to communicate with SQL Server on Azure.

    But with Ambient transaction true, it fails with the following error :

    System.Transactions.TransactionManagerCommunicationException: Communication with the underlying transaction manager has failed. ---> System.Runtime.InteropServices.COMException: The MSDTC transaction manager was unable to push the transaction to the destination transaction manager due to communication problems. Possible causes are: a firewall is present and it doesn't have an exception for the MSDTC process, the two machines cannot find each other by their NetBIOS names, or the support for network transactions is not enabled for one of the two transaction managers. (Exception from HRESULT: 0x8004D02A)

    MSDTC is enabled on both the servers and DTC Ping Test is success.

    I think we need to open some ports for communication. What are the ports that we need to open.

    can you please help.

    Regards,

    Sharmishtha

    Tuesday, August 21, 2018 5:52 AM

All replies