While upgrading our CRM SQL Server to sql 2005 (or rather testing the application after the upgrade), we received the error below.
The transaction active in this session has been committed or aborted by another session.
Error: 3971, Severity: 16, State: 1
The server failed to resume the transaction. Desc:3300000008.
This was not really an upgrade, but a move to a new server.
I found several references to this error, mostly dealing with MS DTC and SQL 2000, but this was 2005 and did not involve linked servers, so the error was odd. It also did not show up in any of our testing for this migration.
The only thing we could think of was that something on the client wasn't working right. We quickly pointed the QA Web layer, which did not have this error, at the new production server, no error. This allowed us to quickly determine the Database layer was working good. We realized that we had not upgraded or rebuilt the web servers, and both the development and QA web servers were fairly new.
We applied mdac 2.8 with no success.
We then applied SNAC, SQL Native Client, and all began working.
MS DTC - http://support.microsoft.com/default.aspx?scid=kb;en-us;329332
A post on google (Link below), combined with the QA success, is what got us thinking that the issue had something to do with MDAC / the client:
Post on google...