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"
Print | posted on Thursday, April 05, 2007 11:52 AM