August 2, 2012 at 2:14 am
Msg 8510, Level 20, State 3, Line 17
Enlist operation failed: 0x8004d01d(XACT_E_CONNECTION_DENIED). 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.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
I was using Linked Server between two Local Area Network Server,
I was trying insert data from Sql server 2008 to sql server 2005 with nest looping, it pop up this error.
August 2, 2012 at 2:55 am
Have you configured the DTC in OS? refer to this article:
http://technet.microsoft.com/en-us/library/cc753620(v=ws.10).aspx
SQL Server use MS DTC to control coordination of transactions .
August 2, 2012 at 3:36 am
I had try this already
And I had Set up already
But still have this Issue
August 2, 2012 at 8:10 am
Have you tried DTCPing tool, the log could show more DTC info:
By the way, could you query each other successfully with Linked server?
August 2, 2012 at 8:32 am
If I run on SQL server it can run,
If I run on exe or application, it will return this error..
I think is permit problem?
August 2, 2012 at 6:58 pm
Can you post a demo how did you run the exe or application, then i could simulate on my server.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply