| Nikhil Rajwade 2004-11-16, 7:46 am |
| Is the target SQL on the same machine or separate machine?
Nikhil Rajwade,
Technical Architect - Sysrepublic.
"John Smith" wrote:
> Hello,
>
> I have following configuration:
>
> - win xp professional sp2
> - sql server 2000 sp3a
> - biztalk 2004 developer edition
> - windows firewall disabled
>
> ms dtc security settings are already set as follows:
> - enabled Network DTC Access
> - Allow remote clients checked
> - Allow Inbound / Outbound checked
> - No authentication required
>
> After applying win xp sp2, I modified rpc settings according to
> article 841893.
> Biztalk server is now working ok, but there is a problem with msdtc
> and sql adapter which access to sql server other then local machine.
> Every message sent to different sql server results with following
> message in event viewer:
>
> The adapter "SQL" raised an error message. Details "New transaction
> cannot enlist in the specified transaction coordinator.
>
> The same orchestrations are working ok when executed from win xp sp1
> machine.
>
> msdtc trace is reporting following errors:
>
> "transaction got begun, description : '<NULL>'"
> "failed to propogate transaction to child node 'SQLServerName' because
> the connection with the remote transaction manager went down"
>
> Adding generated items using Sql adapter fails with message:
> Failed to execute SQL statement. The transaction has already been
> implicitly or explicitly committed or aborted.
>
> This is probably msdtc security problem. Any advice would be
> appreciated.
>
> Thanks.
>
|