Binaryworld - How to configure E-Mail Subscription with SQL Reporting Services. ... [ SQL Server -> Reporting Service ]

When you install reporting services it will ask you for SMTP settings. If you skip those settings then probabbly when you create new subscription you will only see "file share" option.

In order to enable "Email Subscription" you need to do couple of steps.

1. open the RSReportServer.config file (generally located at C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer)

2. Find the <Extension> section.

3. Make sure that you have atleast specified values for SMTPServer and From as shown below

<Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
        <DefaultDeliveryExtension>True</DefaultDeliveryExtension>
        <MaxRetries>3</MaxRetries>
        <SecondsBeforeRetry>900</SecondsBeforeRetry>
        <Configuration>
          <RSEmailDPConfiguration>
            <SMTPServer>localhost</SMTPServer>
            <SMTPServerPort>25</SMTPServerPort>
            <SMTPAccountName></SMTPAccountName>
            <SMTPConnectionTimeout></SMTPConnectionTimeout>
            <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
            <SMTPUseSSL></SMTPUseSSL>
            <SendUsing>2</SendUsing>
            <SMTPAuthenticate></SMTPAuthenticate>
            <From>somevalidemail@mycompany.com</From>
            <EmbeddedRenderFormats>
              <RenderingExtension>MHTML</RenderingExtension>
            </EmbeddedRenderFormats>
            <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
            <ExcludedRenderFormats>
              <RenderingExtension>HTMLOWC</RenderingExtension>
              <RenderingExtension>NULL</RenderingExtension>
            </ExcludedRenderFormats>
            <SendEmailToUserAlias>True</SendEmailToUserAlias>
            <DefaultHostName></DefaultHostName>
            <PermittedHosts></PermittedHosts>
          </RSEmailDPConfiguration>
        </Configuration>
      </Extension>

4. Save the file and open the reporting services manager. Click on any report you have. Click on "New subscription". Now you should see the "Report Server Email" option in "Deliver By" dropdown.

5. Try to setup test subscription by sceduling report (For testing purpose you can set immediate schedule and make sure that you have checked the current day if you testing for the same day).

6. You can check the status of the last Subscription run by clicking on "My Subscriptions" link at the very top.

7. If you running local SMTP configured by IIS then you might get the following error.
"E-mail address of one or more recipients is not valid"

To solve the above error try this

Change the settings on the Relay Restictions on the Access tab for the SMTP Server Properties to be allow relay through the virtual server with "All except the list below" instead of the default "Only the list below". Seems like it should work with the default setting since there is no authentication (anonymous access) but looks like RS doesn't like that.

Hope this helps ...