Enable SharePoint 2013 Integrated SSRS To Send Email Alerts

SQL Server Reporting Services (SSRS), when integrated into SharePoint 2013 enables reports to be sent to users via email.  From the report click Manage Subscriptions.

SharePointSSRS1On the following screen click Add Subscription.  You can configure the report options and click OK to save.

SharePoint SSRS2

If you’ve not configured SSRS you may receive an error in the Application Event log on the SharePoint server hosting the SSRS service application.  This could take the form:

The Report Server Email extension failed to read its configuration settings from the rsreportserver.config configuration file. The extension is not available to users. (Application: SQL Server Reporting Services Service Application, CorrelationId: …)

The web page may also fail to load, with an error like the one below.

SharePoint SSRS3

If you encounter this error, open the SQL Server Reporting Services Service Application from Central Administration.  Next, open e-mail settings and configure the SMTP server.  Finally, open Provision subscriptions and alerts, enter the appropriate account details and click Ok.

SharePoint SSRS4

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s