MS SQL Server Tools - xp_smtp_sendmail and Outlook Express works; Database Mail doesn't

Author

xp_smtp_sendmail and Outlook Express works; Database Mail doesn't

Aaron M. Lowe

2006-03-09, 9:23 am

xp_smtp_sendmail and Outlook Express works; Database Mail doesn't

Hello,

I recently upgrade a SQL 2000 SP4 EE running on Windows 2003 AS to SQL 2005
EE. I was using xp_smtp_sendmail on SQL 2000 through an Exchange server
successfully. However after the upgrade I am unable to send SMTP mail
through Database mail, although testing it through Outlook Express works
successfully.

I've enabled it in Surface Area configuration and here's the results of the
sps
EXEC msdb.dbo. sysmail_help_status_
sp ;
Started

EXEC msdb.dbo. sysmail_help_status_
sp ;
mail 0 RECEIVES_OCCURRING 2006-03-08 04:13:24.843 2006-03-08 04:03:09.857

This is the error I receive:

The mail could not be sent to the recipients because of the mail server
failure. (Sending Mail using Account 1 (2006-03-07T21:50:04). Exception
Message: Could not connect to mail server. (An established connection was
aborted by the software in your host machine).
)

After awhile I'll receive this:

1) Exception Information
===================
Exception Type:
Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException
Message: The Transaction not longer valid.
Data: System.Collections. ListDictionaryIntern
al
TargetSite: Void ValidateConnectionAn
dTransaction()
HelpLink: NULL
Source: DatabaseMailEngine

StackTrace Information
===================
at
Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.ConnectionManager. ValidateConnectionAn
dTransaction()
at
Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.ConnectionManager. RollbackTransaction(
)
at
Microsoft.SqlServer.Management.SqlIMail.IMailProcess.QueueItemProcesser. GetDataFromQueue(Dat
aAccessAdapter
da, Int32 lifetimeMinimumSec)
at
Microsoft.SqlServer.Management.SqlIMail.IMailProcess.QueueItemProcesser. ProcessQueueItems(St
ring
dbName, String dbServerName, Int32 lifetimeMinimumSec, LogLevel
loggingLevel)

Any help would be greatly appreciated.

Thanks,

Aaron Lowe

Aaron M. Lowe

2006-03-10, 1:23 pm

This is resolved now. Evidently McAfee Virus Console 8.0 by default blocks
all mail sent to port 25. Still not sure why the other two work, but
Database mail now works after disabling the block by the McAfee.

"Aaron M. Lowe" <alowe@uic.edu> wrote in message
news:%23bS28s4QGHA.1728@TK2MSFTNGP11.phx.gbl...
> xp_smtp_sendmail and Outlook Express works; Database Mail doesn't
>
> Hello,
>
> I recently upgrade a SQL 2000 SP4 EE running on Windows 2003 AS to SQL
> 2005 EE. I was using xp_smtp_sendmail on SQL 2000 through an Exchange
> server successfully. However after the upgrade I am unable to send SMTP
> mail through Database mail, although testing it through Outlook Express
> works successfully.
>
> I've enabled it in Surface Area configuration and here's the results of
> the sps
> EXEC msdb.dbo. sysmail_help_status_
sp ;
> Started
>
> EXEC msdb.dbo. sysmail_help_status_
sp ;
> mail 0 RECEIVES_OCCURRING 2006-03-08 04:13:24.843 2006-03-08 04:03:09.857
>
> This is the error I receive:
>
> The mail could not be sent to the recipients because of the mail server
> failure. (Sending Mail using Account 1 (2006-03-07T21:50:04). Exception
> Message: Could not connect to mail server. (An established connection was
> aborted by the software in your host machine).
> )
>
> After awhile I'll receive this:
>
> 1) Exception Information
> ===================
> Exception Type:
> Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException
> Message: The Transaction not longer valid.
> Data: System.Collections. ListDictionaryIntern
al
> TargetSite: Void ValidateConnectionAn
dTransaction()
> HelpLink: NULL
> Source: DatabaseMailEngine
>
> StackTrace Information
> ===================
> at
> Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.ConnectionManager. ValidateConnectionAn
dTransaction()
> at
> Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.ConnectionManager. RollbackTransaction(
)
> at
> Microsoft.SqlServer.Management.SqlIMail.IMailProcess.QueueItemProcesser. GetDataFromQueue(Dat
aAccessAdapter
> da, Int32 lifetimeMinimumSec)
> at
> Microsoft.SqlServer.Management.SqlIMail.IMailProcess.QueueItemProcesser. ProcessQueueItems(St
ring
> dbName, String dbServerName, Int32 lifetimeMinimumSec, LogLevel
> loggingLevel)
>
> Any help would be greatly appreciated.
>
> Thanks,
>
> Aaron Lowe
>
>

Sponsored Links