February 13, 2004 at 8:02 am
Error: 8520, Severity: 20, State: 1 Commit of internal MSDTC transaction failed: Result Code = 0x8004d019.
--sntiwary
February 13, 2004 at 8:48 am
Do you run a distributed transaction against a linked server ? Any more information in errorlog?
July 26, 2006 at 1:29 pm
Are you running Windows 2003 os and if using link server are linking to a Windows 2000 os? If so what I did was change settings in msdtc from Mutual Authentication Required to No Authentication required. I don't know the ramifications of doing this on the security side I have only done this in my development box.
July 27, 2006 at 4:53 am
Have you always had this error or has the query previously worked fine?
I've had issues where the MSDTC appears to be running but transactions are failing still.
In the end, the clustered resources were all taken offline and then put back online. MSDTC was online first and then SQL Server.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply