Hi Tim,
I have run into a similar problem. By default, Server 2003 dissabled network
DTC access. To enable it manually, try the following:
In Add Remove Programs/Windows Components, select Application Server, and
check Enable COM+access, and Enable Network DTC access.
Select Component Services from the Admin Tool, select My Computer,
properties MSDTC, then Security Configuration. Check Network DTC Access,
Netwrk Administration, Network Transactions, and Network Clients.
I think you need to have these settings on both boxes, and you may need to
reboot after changing the settings. I'm not sure if these are the optimal
settings but they seem to work for me. I have seen several different
configurtions recommended in different BizTalk docs and whitepapers, I'd love
to know the correct settings...
Hope this helps,
Alan
"TimG" wrote:
> Hi
> I have published an orchestration as a web service running on a machine with
> BTK 2004 and Win 2003. The orchestration calls a stored procedure on a remote
> SQL Server. In the event viewer I am getting the warning
> The adapter "SQL" raised an error message. Details "New transaction cannot
> enlist in the specified transaction coordinator. ".
> and then a couple of unhelpful failed messages
> Everthing works ok if biztalk is on a win xp machine. Any help would be most
> appreciated (DTC) is running both on SQL Server and the BizTalk machines
> Regards
> Tim
|
