Windows error 0x8004D00E, -2147168242

HRESULT: 0x8004D00E using TransactionScope - C#

I received the following error when I tried to run a C# WinForms application on a Windows Server 2003 Standard Edition SP1 machine that was connecting to a SQL server 2000, converting the data in the WinForms app and inserting the converted into a SQL server 2005 application. I am [...] read more

Simple Transactions

I have 2 linq 2 SQL statements I'd like to be in a transaction (the SQL server is remote, outside firewalls etc) all other communication works but when I wrap these 2 statements in a TransactionScope() I begin having to configure MSDTC which we did, but then there are firewall [...] read more

Using transactions across processes

I'm trying to use System.Transactions (TransactionScope) to coordinate a set of processes, each of which does some database work. Ultimately all processes need to commit or be rolled back atomically via one parent process. Unfortunately, nothing I've tried so far works. My basic strategy is to TransactionScope in the parent [...] read more

MSDTC fails intermittently

I have a Windows 2003 server where MSDTC is running. I have set it to No Authentication Mode, with allow inbound-outbound settings. My MSDTC works but it fails for the 1st transaction of the day. On immediate another transaction it will start working. Error is : The transaction has already [...] read more

System.Transactions.TransactionException: The transaction has already been implicitly or explicitly committed or aborted

I have the following code: private void MigrateInTrackingChannelsDbTable(Guid toSsoId, string ctid) { Database database = DatabaseFactory.CreateDatabase("TrackingChannels"); try { using (DbCommand command = database.GetStoredProcCommand("usp_TrackingChannels_MigrateToolbar")) { database.AddInParameter(command, "@ToSSOId", DbType.Guid, toSsoId); database.AddInParameter(command, "@CTID", DbType.String, ctid); database.ExecuteNonQuery(command); } } catch (Exception ex) { Log.Application.Error( string.Format("CPUserService: MigrateInTrackingChannelsDbTable failed with toSsoId:{0}, ctid:{1}", toSsoId, ctid), ex); throw; [...] read more

MS DTC stopped BizTalk's transaction causing stuck message in Receive Pipeline

We had the error that the Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled a transaction of BizTalk which causes some stuck messages in the Receive Port, it has never happened before for years but it just occurs recently in 1 minute which causes few stuck messages. Is there anyway [...] read more

MSDTC Issue - Saving Two Related Entities with Disabling Validation

I am getting a MSDTC error every now then and also specially when I execute my code 1st time. Immediately thereafter the code works fine and then errors out after a while again. I am trying to save my entity - hardware along with a related entity - server that [...] read more