I receive the following error when trying to send a test e-mail to myself with attachments totalling 1.68 MB in size (four copies of the same 0.42 MB file), using sp_send_dbmail on SQL Server 2008.
The mail could not be sent to the recipients because of the mail server failure. (Exception Message: Cannot send mails to mail server. (Exceeded storage allocation. The server response was: 4.3.1 Message size exceeds fixed maximum message size)). I can send the e-mail with three attachments totalling 1.26 MB.
I have changed the MaxFileSize in the Database Mail Configuration Wizard, as shown by the following results from the sysmail_help_configure_sp stored procedure.
paramname paramvalue description
AccountRetryAttempts 1 Number of retry attempts for a mail server
AccountRetryDelay 60 Delay between each retry attempt to mail server
DatabaseMailExeMinimumLifeTime 600 Minimum process lifetime in seconds
DefaultAttachmentEncoding MIME Default attachment encoding
LoggingLevel 2 Database Mail logging level: normal - 1, extended - 2 (default), verbose - 3
MaxFileSize 24576000 Default maximum file size
ProhibitedExtensions exe,dll,vbs,js Extensions not allowed in outgoing mails.
It is not a problem with Outlook, as I have sent and received a 6.4 MB file as a test, and my inbox is nowhere near to its maximum file size. I would be extremely grateful if anyone can provide any possible solutions to this problem.