Re: win2k/sql2k to win2k3/sql2k5 dtc problems

Thanks,

The win2k/sql2k server's DTC service runs as "LocalSystem", the
win2k3/sql2k5 DTC service runs as "NT Authority\NetworkService".

The win2k3/sql2k5 server used to be NT4/sql7 and was upgraded over the
weekend.

Also RCP security has been turned off, and rpc ping and dtc ping both are
successful, however our application keeps coming back with "Communication
Link Failure".

panic


"Sue Hoegemeier" <Sue_H@xxxxxxxxxxxxx> wrote in message
news:3tgat1lccfb19vhin1roajrtd1oukfco8u@xxxxxxxxxx
> In addition to enabling DTC, you may want to check the
> security configuration as well:
> "XACT_E_NOENLIST" error message in DTC and SQL Server
> http://support.microsoft.com/?id=831425
>
> -Sue
>
> On Mon, 23 Jan 2006 13:56:40 -0500, titanic panic
> <jcy1971@googlemailservice> wrote:
>
> >We're having problems running triggers from a win2000/sql2000 server to
> >a win2003/sql2005 server and vice versa.
> >
> >enable network DTC access in add/remove windows components is enabled.
> >
> >What are the steps necessary to ensure that DTC is communicating
> >properly between these two servers?
> >
> >Thanks for any help,
> >
> >panic
>


.

Relevant Pages

  • Re: Transactions and updating two or more MS SQL servers
    ... you'll need to use the DTC. ... > I have a connection set up in the VFP application for each server, ... > I enclose the data updates on each server within Begin Transaction / ... > Commit Transaction pair. ...
    (microsoft.public.fox.vfp.queries-sql)
  • Problems with Win2K3 - DTC and winmgmt in Event Viewer
    ... single CPU server for awhile, ... MSDTC ... Could not start the MS DTC Transaction Manager ...
    (microsoft.public.windows.server.general)
  • Re: LeaseTime can only be set once within an AppDomain.
    ... Visual Studio 2003 only - when I am trying to deploy to my own BizTalk Server ... I have re-installed MSDTC and set the appropriate values in the DTC ... To enable network DTC access and network COM+ access in Windows Server 2003 ...
    (microsoft.public.biztalk.general)
  • Re: COM+/DTC + firewall + SQL Server = need help
    ... Configuring Microsoft Distributed Transaction Coordinator (DTC) to ... Since you are only using one SQL Server, why are you using COM+ distributed ... If you have no need for a distributed transaction stop using transactions ...
    (microsoft.public.sqlserver.security)
  • Re: LeaseTime can only be set once within an AppDomain.
    ... It's from the "Installing and Configuring BizTalk Server in a Multicomputer ... Considerations for Using Distributed Transaction Coordinator ... you must enable network DTC access and network ...
    (microsoft.public.biztalk.general)