[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 Cannot create new connection
 

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

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.