SSRS Subscription maximum message size

• aap2

  SSC Veteran

  Points: 239

  More actions

  May 22, 2008 at 8:55 am

  #182702

  I set up a subscription to send a report each morning as an Excel workbook attachment. However, I get the following message:

  Failure sending mail: The message could not be sent to the SMTP server. The transport error code was 0x800ccc6d. The server response was 552 4.3.1 Message size exceeds fixed maximum message size

  How/Where do I set the configuration for maximum message size in the Reporting Services?

  Thanks,

  aap2

• SUBRAHMANYA HEDGE

  SSCommitted

  Points: 1514

  More actions

  March 22, 2012 at 4:35 am

  #1462595

  << Replying to a pretty old thread as there was no reply to this thread >>

  We encountered a same issue when we newly configured our reporting server for E-Mail delivery. You can change the Message Size on the SMTP reporting server.

  - Open IIS 6.0 on the server where your report server for e-mail delivery is configured. It can be the same machine where your SQL Server reporting server is hosted or a different machine. (Refer below link on how to set up a report server for e-mail delivery -

  http://msdn.microsoft.com/en-us/library/ms159155.aspx )

  - Go to SMTP Virtual Server on IIS 6.0. Open Properties.

  - Go to tab "Messages". Change the message size as per your requirement ( This can't be more than SMTP server's max limit)

  - Save and recycle SMTP Virtual Server

  - Also recycle service "Simple Mail Transfer Protocol (SMTP)"

  Then try sending the mail again. This worked for us.