Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Thursday, February 21, 2019 4:16 PM
Hi
I have upgraded an SQL 2012 server to SP4 and 24 hours after the upgrade a had a spate of 4 of the following errors in the SQL event log.
Import of Microsoft Distributed Transaction Coordinator (MS DTC) transaction failed: 0x8004d00e(XACT_E_NOTRANSACTION).
Error: 8509, Severity: 16, State: 1.
The server has a second instance of SQL2008 on it, but the error is reporting from the 2012 Server.
The server is not part of a cluster.
SAGECRM is the software using jTDS to talk to a database on the server.
Does anyone have any ideas what may be causing this, as all other links point to it occuring only on clusters and this is not a cluster.
Thanks in advance
Friday, February 22, 2019 8:34 AM
Hi Jon Howes,
>>Import of Microsoft Distributed Transaction Coordinator (MS DTC) transaction failed: 0x8004d00e(XACT_E_NOTRANSACTION).
From the error message, I can searched the blog. In the blog, the error is related to MS DTC changes in Windows Server cluster. However, you said that your server is out of part of cluster.
Could you please tell us more details for the error log. You can also upload the error log to any trusted network disk and share the link here. Please pay attention to mask your private information.
Best Regards,
Emily
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com