The adapter "SQL" raised an error message. Details "A connection with the transaction manager was lost.

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?