August 22, 2011 at 11:18 pm
HI all ,
Its very urgent for me. i got this error from SQL error log .
Enlist operation failed: 0x8004d01c(error not found). 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.
Due to this error we are unable to connect from the applications .
Please advise on this , what is the root cause for this error .
Thanks
Lavanya sri
August 24, 2011 at 2:57 am
Have you Googled MSDTC Troubleshooting? There are a lot of very useful articles at the top of the result list that should help you.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
August 25, 2011 at 2:34 am
Thank you,
My issue was resolved .
August 25, 2011 at 4:10 pm
If you don't mind, please post the steps you took to correct the issue to allow others finding this thread via a search engine to learn.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
August 26, 2011 at 12:09 am
could you provide the steps??
September 1, 2011 at 6:09 am
HI ,
I am having trouble creating a maintenance plan through the GUI, since there appears to be a version mismatch between SQL Server Management Studio and the Database Engine. The DB Engine is currently patched up to SP3 (v9.0.4035) while Management Studio has had no service packs applied at all (v9.0.1399)
I was able to get all SQL components to the same patch level [SP3] .
Thanks
Lavanya sri
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply