与Azure上的SQL Server通信时出错 [英] Error Communicating with SQL Server on Azure

问题描述

我在内部有一个BizTalk 2010应用程序，试图与Azure上的SQL Server通信.

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

我们使用带有SQL绑定的WCF-Custom进行通信.如果我们在发送端口禁用环境事务，则可以与Azure上的SQL Server通信.

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.

但是如果Ambient事务为true，它将失败，并显示以下错误:

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

System.Transactions.TransactionManagerCommunicationException:与基础事务管理器的通信失败. ---> System.Runtime.InteropServices.COMException:MSDTC事务管理器无法将事务推送到目标 交易经理由于沟通问题.可能的原因是:存在防火墙，并且MSDTC进程没有例外，两台计算机无法通过其NetBIOS名称相互查找，或者对网络事务的支持为 没有为两个事务管理器之一启用. (来自HRESULT的异常:0x8004D02A)

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，并且DTC Ping测试成功.

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.

请您帮忙.

此致

Sharmishtha

Sharmishtha

推荐答案

Hi Sharmishtha，

Hi Sharmishtha,

请查看来自BizTalk论坛的以下MSDN线程:

Please take a look at the below MSDN thread from the BizTalk forum:

如果您还有其他疑问，请告诉我们.

Please let us know if you have any additional questions.

谢谢

迈克

这篇关于与Azure上的SQL Server通信时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！