Enlist of MSDTC transaction failed

Question

Enlist of MSDTC transaction failed

Helen-84411

Hall of Fame

Points: 3320
More actions
December 12, 2005 at 7:55 am

#166807

Hi all,
I get this error in error log
Error: 8510, Severity: 20, State: 1 Enlist of MSDTC transaction failed: Result Code = 0x8004d00e.
WE have MSDTC running and we have linked servers.
Any help
I have captured a profile with Transaction Events. Don't know how to dig in to find why the error occured

Helen
--------------------------------
Are you a born again. He is Jehova Jirah unto me

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 1

If you're running on Windows Server 2003, you'll need to set up DTC for network access. If you recently applied SP1 for Windows Server 2003, realize that even if you have the settings correct before, the service pack resets them. Here is an article that will help you out if running on Windows Server 2003 is the issue:

How to enable network DTC access in Windows Server 2003 (817064)

K. Brian Kelley
@kbriankelley

Helen-84411 Hall of Fame Points: 3320 More actions · Answer 2

Thanks a lot Brain. But I am running on Windows 2000 advanced server.

Any help?

Helen
--------------------------------
Are you a born again. He is Jehova Jirah unto me

peterhe SSChampion Points: 11469 More actions · Answer 3

Did you get this error every time when you started a distributed transaction, or just occasinally?

There is a ms kb article http://support.microsoft.com/?kbid=307802 for sql 2000. Not sure it's helpful or not.

Arun-426971 Old Hand Points: 310 More actions · Answer 4

Even I am getting the same error.I am running on Windows Server 2003 with SP1

Please Help!!!

peterhe SSChampion Points: 11469 More actions · Answer 5

I summarized the solution to the MSDTC issue in one of my blog. Take a look and see whether it's helpful.

http://p-sql.spaces.live.com/?_c11_blogpart_blogpart=blogview&_c=blogpart&partqs=amonth%3d2%26ayear%3d2007

Lavanyasri SSCarpal Tunnel Points: 4907 More actions · Answer 6

HI ,

I had the same issue but i am using the windows 2008 .

Import of Microsoft Distributed Transaction Coordinator (MS DTC) transaction failed: 0x8004d01c(error not found).

Error: 8509, Severity: 16, State: 1.

Enlist operation failed: 0x8004d01c(error not found). SQL Server could not register with Microsoft Distributed Transaction Coordinator (MS DTC) as a resource manager for this transaction. The transaction may have been stopped by the client or the resource manager.

Error: 8510, Severity: 20, State: 3.