xp_smtp_sendmail and Outlook Express works; Database Mail doesn't

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.GetD
 ataFromQueue(DataAcc
essAdapter
da, Int32 lifetimeMinimumSec)
at
Microsoft.SqlServer.Management.SqlIMail.IMailProcess.QueueItemProcesser.Proc
 essQueueItems(String

dbName, String dbServerName, Int32 lifetimeMinimumSec, LogLevel
loggingLevel)

Any help would be greatly appreciated.

Thanks,

Aaron Lowe

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.ConnectionManage
r. ValidateConnectionAn
dTransaction()
> at
> Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.ConnectionManage
r. RollbackTransaction(
)
> at
> Microsoft.SqlServer.Management.SqlIMail.IMailProcess.QueueItemProcesser.Ge
 tDataFromQueue(DataA
ccessAdapter
> da, Int32 lifetimeMinimumSec)
> at
> Microsoft.SqlServer.Management.SqlIMail.IMailProcess.QueueItemProcesser.Pr
 ocessQueueItems(Stri
ng
> dbName, String dbServerName, Int32 lifetimeMinimumSec, LogLevel
> loggingLevel)
>
> Any help would be greatly appreciated.
>
> Thanks,
>
> Aaron Lowe
>
>