Import of MSDTC transaction failed: Result Code = 0x8004d00e

17 Mar 2006 5:01 PM

BF

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.

17 Mar 2006 9:29 PM

BF

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.

Show quote

"BF" wrote:

> 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.
>

17 Mar 2006 10:19 PM

BF

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.

Show quote

"BF" wrote:

> 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.
>
> "BF" wrote:
>
> > 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.
> >