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.
Bij Cadac maken we onderscheid tussen Sales, Service & Support. Sales & Service vinden wij vanzelfsprekend. Wij helpen u met de aanschaf van uw product, dienst, training of expert en zorgen ervoor dat u probleemloos aan de slag kunt. Gratis en voor niets. U kunt zorgeloos met uw software starten, wij zorgen ervoor dat u het meeste uit uw software kunt halen.
Loopt u tegen technische softwareproblemen aan? Dan kunt u gebruik maken van Cadac Support. Door de juiste informatie in te dienen kunnen wij u zo snel mogelijk helpen