Hi ,

I've configure a sql 2005 server DB mail. I'm not able to send email with
attachment bigger than 5 MB. But I'm able to send a mail with attachment
size less than 5 MB.

The SQL DB mail is configured to send mail of maximum size 15 MB. The port
25 is open on the server and antivirus software is configure to to trust the
SQL DB mail process.

I could get following information from the system event logger and sysmail log
tables.

mail server. (The operation has timed out.)

1) Exception Information
===================
Exception Type:
Microsoft.SqlServer.Management.SqlIMail.Server.Com mon.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.Dat aAccess.ConnectionManager.ValidateConnectionAndTra nsaction()
at
Microsoft.SqlServer.Management.SqlIMail.Server.Dat aAccess.ConnectionManager.RollbackTransaction()
at
Microsoft.SqlServer.Management.SqlIMail.IMailProce ss.QueueItemProcesser.GetDataFromQueue(DataAccessA dapter
da, Int32 lifetimeMinimumSec)
at
Microsoft.SqlServer.Management.SqlIMail.IMailProce ss.QueueItemProcesser.ProcessQueueItems(String
dbName, String dbServerName, Int32 lifetimeMinimumSec, LogLevel
loggingLevel)

failure. (Sending Mail using Account .....XXX. Exception Message: Cannot
send mails to mail server. (Failure sending mail.). )

failure. (Sending Mail using Account ...XXXX..... Exception Message: Cannot
send mails to mail server. (The operation has timed out.).

The same configuration works from other server (Test server)

Please can anyone help me.

Thank you in advance

From,
Rajesh Bhokse

I'd first test the SMTP server by sending an email with a 5MB attachment
using an SMTP client (i.e. without involving SQL Server). It may be a setting
on the SMTP side that's the root of the problem.

On a different note, why are you sending such a large email via SQL database
mail? I'm not sure it's a good idea.

Linchi

"Rajesh" wrote:

I'd first test the SMTP server by sending an email with a 5MB attachment
using an SMTP client (i.e. without involving SQL Server). It may be a setting
on the SMTP side that's the root of the problem.

On a different note, why are you sending such a large email via SQL database
mail? I'm not sure it's a good idea.

Linchi

"Rajesh" wrote:

I'd first test the SMTP server by sending an email with a 5MB attachment
using an SMTP client (i.e. without involving SQL Server). It may be a setting
on the SMTP side that's the root of the problem.

On a different note, why are you sending such a large email via SQL database
mail? I'm not sure it's a good idea.

Linchi

"Rajesh" wrote:

I'd first test the SMTP server by sending an email with a 5MB attachment
using an SMTP client (i.e. without involving SQL Server). It may be a setting
on the SMTP side that's the root of the problem.

On a different note, why are you sending such a large email via SQL database
mail? I'm not sure it's a good idea.

Linchi

"Rajesh" wrote:

I'd first test the SMTP server by sending an email with a 5MB attachment
using an SMTP client (i.e. without involving SQL Server). It may be a setting
on the SMTP side that's the root of the problem.

On a different note, why are you sending such a large email via SQL database
mail? I'm not sure it's a good idea.

Linchi

"Rajesh" wrote:

I'd first test the SMTP server by sending an email with a 5MB attachment
using an SMTP client (i.e. without involving SQL Server). It may be a setting
on the SMTP side that's the root of the problem.

On a different note, why are you sending such a large email via SQL database
mail? I'm not sure it's a good idea.

Linchi

"Rajesh" wrote:

I'd first test the SMTP server by sending an email with a 5MB attachment
using an SMTP client (i.e. without involving SQL Server). It may be a setting
on the SMTP side that's the root of the problem.

On a different note, why are you sending such a large email via SQL database
mail? I'm not sure it's a good idea.

Linchi

"Rajesh" wrote:

I'd first test the SMTP server by sending an email with a 5MB attachment
using an SMTP client (i.e. without involving SQL Server). It may be a setting
on the SMTP side that's the root of the problem.

On a different note, why are you sending such a large email via SQL database
mail? I'm not sure it's a good idea.

Linchi

"Rajesh" wrote:

I'd first test the SMTP server by sending an email with a 5MB attachment
using an SMTP client (i.e. without involving SQL Server). It may be a setting
on the SMTP side that's the root of the problem.

On a different note, why are you sending such a large email via SQL database
mail? I'm not sure it's a good idea.

Linchi

"Rajesh" wrote: