How to enable Reporting email subscriptions?

Laatst gewijzigd op: 6 April 2020

This article describes how you can enable the email subscription feature of SQL Server Reporting Services in SharePoint (Integrated).

Precondition

Make sure that "SSRS - SharePoint" is installed and correctly configured, and you can run a report from a site collection.

Also, ensure that outgoing email is configured and working

Steps to be taken:

Go to Central Administration --> Application Management --> Manage Service Applications --> SQL Server Reporting Services --> E-mail settings
Fill in the SMTP (mail)server that will be used to send the reports to end users:
Go to Central Administration --> Application Management --> Manage Service Applications --> SQL Server Reporting Services --> Provision Subscriptions and Alerts
Make sure that the SQL Server Agent is running according to SharePoint (see screenshot)
1. If it doesn't match the status "SQL Server Agent is running", please check the SQL Server Agent service on the SQL Server
Click the "Download Script" button to download the SQL Server Agent script.
Copy the (contents of the) script to the SQL Server and run the script in SQL Server Management Studio or via CLI:
On a site collection, open a report and select in the top left Actions --> Subscribe
You should now have the option to select Email as one of the ways to subscribe.

At Cadac, we distinguish between Sales, Service & Support. We take Sales & Service for granted. We help you purchase your product, service, training or expert and make sure you can get started without any problems. Free of charge and for nothing. You can start using your software carefree, we make sure you can get the most out of it. Are you running into technical software problems? Then you can use Cadac Support. By submitting the correct information, we can help you as quickly as possible.