Environment:
– BizTalk 2004 works on the CORPBTS1 server (Windows Server 2003)
– SQL Send ports send the messages to the SQL 2000 DB on the CORPNT5 server .

 

After installing the SP2 for Windows Server 2003 I’ve got the events:

 


Event Type: Error
Event Source: BizTalk Server 2004
Event Category: BizTalk Server 2004
Event ID: 5754
Date:  …
Time:  …
User:  N/A
Computer: CORPBTS1
Description:
The “SQL” adapter is suspending an outbound message going to destination URL:”SQL://CORPNT5/Prod/“. Details:”New transaction cannot enlist in the specified transaction coordinator. “.


 

When I try to Refresh the SQL Adapter Receive/Send handlers I’ve got the errors that something wrong with Distributed transaction coordinator (DTC).

 

More interesting was that I work with database on the CORPNT5 server through the .NET code from the map (with the Enterprise Library), and this works fine!

 

The problem was resolved when I changed on the CORPBTS1:
Administrative Tools \ Component Services \ My Computer \ Properties \ MSDTC \ Security Configuration \ Transaction Manager Communication \ “Mutual Authentication Required” –> “Incoming Caller Authentication Required”