Monday, February 20, 2012

Reporting Services: Subsciption E-mail Not Sending

After setting up a subscription in reporting services you send an email and it reports that it sent it successfully, but no email is sent. It will send to a file share. Any suggestionsMake sure you have the correct SMTP server value set up. Are you on RS 2000 or 2005?|||It is all setup I can email from intergration services packages and backup jobs, but the reporting services I believe is being blocked at our firewall. What format is the body of the document written, and is there a way to change it? Is the report inserted or attached?|||

The report is embeded in the body if you choose Web Archive format, otherwise it is attached. The format for the body is UTF-8 (I believe, going off memory here).

We generally suggesting using a local SMTP to relay the messages and having RS drop the files to the SMTP Servers pickup directory. More info on configuring the email extension can be found here:

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

No comments:

Post a Comment