sp_send_dbmail Message size exceeds fixed maximum message size

Question

sp_send_dbmail Message size exceeds fixed maximum message size

Frustrated

Old Hand

Points: 377
More actions
November 2, 2011 at 6:12 pm

#146617

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.
paramnameparamvaluedescription
AccountRetryAttempts1Number of retry attempts for a mail server
AccountRetryDelay60Delay between each retry attempt to mail server
DatabaseMailExeMinimumLifeTime600Minimum process lifetime in seconds
DefaultAttachmentEncodingMIMEDefault attachment encoding
LoggingLevel2Database Mail logging level: normal - 1, extended - 2 (default), verbose - 3
MaxFileSize24576000Default maximum file size
ProhibitedExtensionsexe,dll,vbs,jsExtensions 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.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Are the message being sent from the same account? It may be that the Exchange admin is administering attachment size by user/group vs. the whole domain.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Lowell SSC Guru Points: 323546 More actions · Answer 2

Jack this was a double post;

In another thread we tracked down the issue:

http://www.sqlservercentral.com/Forums/FindPost1200033.aspx

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Jack Corbett SSC Guru Points: 184394 More actions · Answer 3

At least it looks like I pointed to the same issue.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Frustrated Old Hand Points: 377 More actions · Answer 4

Thanks Jack. I apologise for the double post. I submitted it to the SQL 2005 forum by mistake yesterday, and did not know how to delete it. Yesterday was one of those days.