Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Please help!!! XACT_E_CONNECTION_DENIED!!!! Expand / Collapse
Author
Message
Posted Thursday, August 2, 2012 2:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 2, 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
Posted Thursday, August 2, 2012 2:55 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 9:21 PM
Points: 125, Visits: 1,061
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
Posted Thursday, August 2, 2012 3:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 2, 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
Posted Thursday, August 2, 2012 8:10 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 9:21 PM
Points: 125, Visits: 1,061
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
Posted Thursday, August 2, 2012 8:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 2, 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
Posted Thursday, August 2, 2012 6:58 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 9:21 PM
Points: 125, Visits: 1,061
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 »

Add to briefcase

Permissions Expand / Collapse