Import of MSDTC transaction failed: Result Code = 0x8004d00e

[Guest]

After I used TransactionScope in my C# application to update multiple tables
in 2 databases on the same SQL 2000 server. I got error "Import of MSDTC
transaction failed: Result Code = 0x8004d00e".

This problem happens only after I deployed this application to our Windows
Server 2003 Standard Edition.

But I don't have this problem when I run this application on my local
Windows XP Professional computer.

I think this problem is caused by MSDTC is not enabled on the server. Can
anybody show to how to enable MSDTC on the server?

Thanks a lot.

 

[Guest]

I just want to add one more information. The C# application and the SQL 2000
server are on the same computer. So we should not have firewall issues here.
Does anybody know how to fix this problem?

Thanks a lot.

 

[Guest]

Now I found out where the problem is. It's because I open too many connection
objects and TransactionScope hold them open even I after I closed them. I
will post another question for this.