SQL适配器和DTC问题 [英] SQL Adapter and DTC problem

问题描述

我们部署了BizTalk解决方案，每四周（或左右）部署一次，BizTalk会生成以下事件：

"适配器" SQL"提出了一条错误信息。详细信息"与事务管理器的连接丢失。 （Exception HRESULT：0x8004D01C）"。

此错误源自使用SQL适配器调用简单存储过程的业务流程。每隔一段时间就没有问题，编排正常完成。我们必须重新启动BizTalk主机才能使业务流程脱水并从中断处继续。 AfterBizTalk重新启动后，它能够完成存储过程调用并继续发生任何事情。

我们有2台运行BTS 2006的BizTalk服务器，而SQL服务器是主动/被动集群。 BizTalk服务器上的DTC安全设置为"无身份验证"，因为我们还与Windows 2000上的Sql Server进行通信。有问题的SQL Server上的DTC设置设置为"需要传入呼叫者身份验证"。

是否还必须将此设置为无需身份验证？有哪些安全风险？

解决方案

以下是有关DTC设置中身份验证选项的一些信息：http://support.microsoft.com/kb/899191/

We have a BizTalk solution deployed and once every four weeks (or so), BizTalk generates the following event:

"The adapter "SQL" raised an error message.  Details "A connection with the transaction manager was lost. (Exception HRESULT: 0x8004D01C)".

This error is originating from an orchestration that is using the SQL adapter to call a simple stored procedure.  Every other time there is no issue and the orchestration completes normally. We have to restart the BizTalk host to get the orchestration to un-dehydrate and pick up where it left off.  AfterBizTalk is restarted, it is able to finish the stored procedure call and continue like nothing ever happend.

We have 2 BizTalk servers running BTS 2006 and the SQL server is an active/passive cluster. DTC security settings on the BizTalk servers are 'No authentication' as we also talk to a Sql Server on Windows 2000. The DTC setting on the problematic SQL Server is set to 'Incoming Caller Authentication Required'.

Does this one also have to be set to No Authentication required? What are the security risks of that?

解决方案

Here is some information regarding the authentication options in the DTC Settings: http://support.microsoft.com/kb/899191/

这篇关于SQL适配器和DTC问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！