Cannot create new connection because in manual or distributed transaction mode.

Applies to: Microsoft SQL Server 2005, MailMarshal SMTP 2006 / 6.1

Error Message.

Event Type: Error
Event Source: MMArrayManager
Event Category: None
Event ID: 3501
Date: 12/8/2007
Time: 8:01:28 PM
User: N/A
Computer: MAILMARSH
Description:

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)

Problem Description.

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.


Solution.

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.

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.