Import of MSDTC transaction failed

Error: 8509, State: 1, Message: Import of MSDTC transaction failed: Result
Code = 0x8004d00e
I can not find any help on many websites.
How to do it?The error message says that SQL Server can not enlist in the transaction
that is provide because the transaction is already implicitly or explicitly
committed or aborted.
Which OS are you on? If you are using Windows XP or Windows Server 2003 you
can use DTC trace to find out why the transaction import failed. If you do
not have this OS, you could use AppMetrics from ExtermeSoft see
http://www.xtremesoft.com
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2004 All rights reserved.
"lv mingtong" <lmt@.taeco.com.discuss> wrote in message
news:eUww2DIlEHA.1644@.tk2msftngp13.phx.gbl...
> Error: 8509, State: 1, Message: Import of MSDTC transaction failed: Result
> Code = 0x8004d00e
> I can not find any help on many websites.
> How to do it?
>|||I too am having this issue. The db is running on Win XP Professional,
SQL Server 2K + ASP.NET app. It is an intermittent issue and occurs
every 4th hit to any page. I am using
System.EnterpriseServices.AutoCompleteAttribute(True) to auto commit
the transaction. The strange thing is that if I hit the maching
remotely it is fine...If I do it locally the error will appear.
Eg.
Scenario #1: Works and is fine:
Machine A = Web App, dll's etc
Machine B = DB server
Scenario #2: Generates the error "Import of MSDTC transaction failed:
Result Code = 0x8004d00e."
Machine A = Web App, dll's etc + DB server
It is a strange issue that is not constant.
Any suggestions will be attempted...no matter how bizzare :)
Thanks|||I too am having this issue. The db is running on Win XP Professional,
SQL Server 2K + ASP.NET app. It is an intermittent issue and occurs
every 4th hit to any page. I am using
System.EnterpriseServices.AutoCompleteAttribute(True) to auto commit
the transaction. The strange thing is that if I hit the maching
remotely it is fine...If I do it locally the error will appear.
Eg.
Scenario #1: Works and is fine:
Machine A = Web App, dll's etc
Machine B = DB server
Scenario #2: Generates the error "Import of MSDTC transaction failed:
Result Code = 0x8004d00e."
Machine A = Web App, dll's etc + DB server
It is a strange issue that is not constant.
Any suggestions will be attempted...no matter how bizzare :)
Thanks