Schedule Report – Delivery Method – No Email Option


I can see this as being a common setting to overlook, so thought I would write a quick blog on it.

If you want to schedule a report for delivery to an email recipient, first you’ll need to configure SSRS with a valid email server.  Otherwise, you will not have the email option available while configuring your scheduled report delivery.

Subscribe to a Report: No email option

Subscribe - no email option

Logon to the Report Server, and launch Reporting Services Configuration.

Open Reporting Services Configuration

Click Email Setting in left pane, and fill in Sender Address and SMTP Server fields.  Then click apply.

SRS Email settings

You should now have a green check next to Email Settings in left pane.

Configured

Go back to schedule a report, and E-Mail option is now available.

Subscribe - email option


Comments (4)

  1. Ricardo Peres says:

    Thank you very much, You made my day. Thanks

  2. Kman says:

    Thank you so much!.  You saved the day :-)

  3. Stan Vandiver says:

    Solved the issue for me as well. Isn't the sharing of information great!

    Thanks.

  4. Magg says:

    Thanks a lot. Very helpful article