Please help!!! XACT_E_CONNECTION

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Please help!!! XACT_E_CONNECTION_DENIED!!!!

Please help!!! XACT_E_CONNECTION_DENIED!!!!

Rate Topic

Display Mode

Topic Options

Author

Message

matthew90510

Posted Thursday, August 02, 2012 2:14 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, August 02, 2012 9:54 PM
Points: 3, Visits: 3

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.

Post #1338999

DBA328

Posted Thursday, August 02, 2012 2:55 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 2:13 AM
Points: 116, Visits: 792

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 .

[li][/li]

Post #1339014

matthew90510

Posted Thursday, August 02, 2012 3:36 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, August 02, 2012 9:54 PM
Points: 3, Visits: 3

I had try this already
And I had Set up already
But still have this Issue

Post #1339033

DBA328

Posted Thursday, August 02, 2012 8:10 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 2:13 AM
Points: 116, Visits: 792

Have you tried DTCPing tool, the log could show more DTC info:

http://blogs.msdn.com/b/distributedservices/archive/2008/11/12/troubleshooting-msdtc-issues-with-the-dtcping-tool.aspx

By the way, could you query each other successfully with Linked server?

[li][/li]

Post #1339196

matthew90510

Posted Thursday, August 02, 2012 8:32 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, August 02, 2012 9:54 PM
Points: 3, Visits: 3

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?

Post #1339216

DBA328

Posted Thursday, August 02, 2012 6:58 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 2:13 AM
Points: 116, Visits: 792

Can you post a demo how did you run the exe or application, then i could simulate on my server.

[li][/li]

Post #1339589

« Prev Topic | Next Topic »

Permissions