June 13, 2006 at 1:36 pm
I'm getting the following in the database mail log file when I try to send an email using Database Mail:
Date 6/13/2006 2:19:38 PM
Log Database Mail (Database Mail Log)
Log ID 111
Process ID 5500
Mail Item ID 33
Last Modified 6/13/2006 2:19:38 PM
Last Modified By sa
Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 5 (2006-06-13T14:19:38). Exception Message: Cannot send mails to mail server. (The operation has timed out.).
)
I can send SMTP from the server through the command line. I also get the following after the database mail process shuts down:
Date 6/13/2006 2:28:58 PM
Log Database Mail (Database Mail Log)
Log ID 112
Process ID 5500
Last Modified 6/13/2006 2:28:58 PM
Last Modified By
Message
1) Exception Information
===================
Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException
Message: The Transaction not longer valid.
Data: System.Collections.ListDictionaryInternal
TargetSite: Void ValidateConnectionAndTransaction()
HelpLink: NULL
Source: DatabaseMailEngine
StackTrace Information
===================
at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.ConnectionManager.ValidateConnectionAndTransaction()
at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.ConnectionManager.RollbackTransaction()
at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.QueueItemProcesser.GetDataFromQueue(DataAccessAdapter da, Int32 lifetimeMinimumSec)
at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.QueueItemProcesser.ProcessQueueItems(String dbName, String dbServerName, Int32 lifetimeMinimumSec, LogLevel loggingLevel)
Has anyone seen this before? Is it a bad install?
June 13, 2006 at 3:41 pm
I fixed the issue. I had this working on other servers and couldn't understand why. Then I rebooted my server and it started working. After thinking about it, I rebooted all of the servers as the last thing I did.
I think that you need to reboot the server (not just restart the services) after you configure Database mail. Hope this helps the next person.
June 16, 2006 at 12:58 pm
I am getting this same error message. I have rebooted several times & still receive the error. Anyone else have any ideas to resolve this?
I am running SQL 2005 Enterprise 64 bit edition on Win 2003 Enterprise 64 bit edtion
THanks!
John
July 25, 2008 at 7:41 am
I'm having the same issue as well.
I have a 64 bit machine running SQL 2005 64 bit Enterprise Edition SP 2 on a Windows 2003 Standard 64 bit Sp 2.
It appears, emails work fine for a while, then they stop saying it could not connect to the mail server.
July 26, 2008 at 3:53 pm
Another issue that I had was with the antivirus email not allowing the mail to be sent. You might want to deinstall it.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply