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)
- If it doesn't match the status "SQL Server Agent is running", please check the SQL Server Agent service on the SQL Server
- 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.