MS SQL Server DTS - "Distributed Transaction Error" 2000 -> 2003

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

"Distributed Transaction Error" 2000 -> 2003

irfan bashir

2005-07-26, 7:23 am

I am getting "Distributed Transaction Error" when connecting to SQL Server
2000 from my COM+ application via DSN.
My SQLServer2000 is running on Windows Server 2003 with Network DTC enabled
My COM+ applicaiton is running on Windows 2000 Pro.
I have reviewed many posts regarding this problem, all of them suggesting
that Network DTC should be enabled. BUT this is already enabled and COM+
applications running on windows 2003 server are communicating and executing
fine.

COM+ on 2003 is the configuration on our running servers. We have to debug
that application using 2000 Pro as COM+ client for the same 2003 SQL Server2k
deployment.

The problem is SURELY with 2000 being the client.
We cannot seem to find any solution for this.

Sponsored Links