Cannot create new connection because in manual or distributed transaction
Applies to: Microsoft SQL Server 2005, MailMarshal SMTP 2006 / 6.1
Event Type: Error
Event Source: MMArrayManager
Event Category: None
Event ID: 3501
Time: 8:01:28 PM
Failed to load logfile. Failed to process log file database exception- Execute
error: 0x80004005 - Cannot create new connection because in manual or
distributed transaction mode.: UPDATE MMReceiver SET BlockCount = 2 WHERE Name =
'Connection Policies:Deny message to unknown users' AND BlockType = 0 AND
EntryDate >= '2007-12-09 00:00:01' AND EntryDate <= '2007-12-09 23:59:59':Error
0x80004005 - Cannot create new connection because in manual or distributed
transaction mode. (Source: Microsoft OLE DB Provider for SQL Server, SQL State
(null), NativeError 0)
Using SQL Server Profiler we determined that all SQL update statements coming from MailMarshal server to the MailMarshal database in Microsoft SQL Server 2005 were
failing. Meanwhile, some inserts and all SQL delete statements were successful.
MailMarshal was uninstalled, then reinstalled, and finally upgraded to
MailMarshal 6.2.23. This problem was first fixed in version 6.2.0.
If you cannot upgrade immediately, there is a workaround at MailMarshal
Knowledge base article #11907.