SQL Server Performance Forum – Threads Archive
Error: 8510Distributed Transaction Error
Machine 1 (Transaction Initiator) – Windows 2003 Server with SP1 and DTS Enabled and configiured and settings enabled as per the link below
Machine 2 – same as above
Database : SQL SERVER 2005 WITH SP2 Installed
Hi I am getting an error while running a .NET App and Calling a Transactional Stored Procedure.
The ADO object makes a call to the Stored Procedure which is wraped between a
BEGIN DISTRIBUTED TRANSACTION and COMMIT TRANSACTION
have the XACT_ABORT ON
Error: 8510, Severity: 20, State: 2. Message
Enlist operation failed: 0x8004d00e(XACT_E_NOTRANSACTION). 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. Kindly suggest on what have to be done on this.This is getting too critical
Make sure MSDTC is running…
The following issue is in 2000…I don’t know it applies to 2005 or not… http://support.microsoft.com/default.aspx?scid=kb;en-us;Q307802
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.
Refer below thread
http://forums.microsoft.com/MSDN/ShowPost.aspx?PageIndex=2&SiteID=1&PostID=1390804 Hemantgiri S. Goswami
MS SQL Server MVP
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami http://hemantgirisgoswami.blogspot.com
Mohammed’s KBA partly relates to SQL 2005 too, refer to this KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;289751 on the operating system fix. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.