Re: win2k/sql2k to win2k3/sql2k5 dtc problems

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: 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)
  • 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)