1. Home
  2. Service & Support
  3. Support
  4. Organice
  5. How to
  6. How to enable Reporting email subscriptions?

How to enable Reporting email subscriptions?

How to

Last modified on 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: 

  1. Go to Central Administration --> Application Management --> Manage Service Applications --> SQL Server Reporting Services --> E-mail settings
  2. Fill in the SMTP (mail)server that will be used to send the reports to end users:
  3. Go to Central Administration --> Application Management --> Manage Service Applications --> SQL Server Reporting Services --> Provision Subscriptions and Alerts
  4. 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
  5. Click the "Download Script" button to download the SQL Server Agent script.
  6. Copy the (contents of the) script to the SQL Server and run the script in SQL Server Management Studio or via CLI:
  7. On a site collection, open a report and select in the top left Actions --> Subscribe
  8. 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.

Ask a question

What do you have a question about?

  • Support
  • Sales
  • Service
Log in to receive your personal prices

Log in to My Cadac

You are logged out

You have entered the wrong email address or password

New to Cadac Group?

  • The best prices Discover your personal price after creating an account
  • Buy or extend your Autodesk products Buy or extend your Autodesk products
  • Clear and easy to use webshop Clear and easy to use webshop
Need help? Service & Support

Create an account

Your password must be at least 8 characters long, and include at least one lowercase letter, one uppercase letter, and a number.

You have left some fields blank or not completed them correctly

This email address is already in use.

Privacy statement

Why create an account?

  • The best prices The best prices
  • Buy or extend your Autodesk products Buy or extend your Autodesk products
  • Clear and easy to use webshop Clear and easy to use webshop
Need help? Service & Support

Forgotten password

Having problems logging in? Enter your email address. You will then receive a link where you can reset your password. If you're not sure which email address was used, get in touch with us.

You have entered an invalid email address.

We do not have a record of this email address in our system.

Oops... An error occurred, please get in touch with us.

New to Cadac Group?

  • The best prices Discover your personal price after creating an account
  • Buy or extend your Autodesk products Buy or extend your Autodesk products
  • Clear and easy to use webshop Clear and easy to use webshop
Need help? Service & Support

Forgotten password

You have been sent an email from us with a link to reset your password.

New to Cadac Group?

  • The best prices Discover your personal price after creating an account
  • Buy or extend your Autodesk products Buy or extend your Autodesk products
  • Clear and easy to use webshop Clear and easy to use webshop
Need help? Service & Support

Reset password

Unfortunately, your link has expired or is invalid.
Click on the button below to request a new link.

Enter your new password below.

Your password must be at least 8 characters long, and include at least one lowercase letter, one uppercase letter, and a number.

Password only entered once or passwords do not match.

We do not have a record of this email address in our system.

Oops... An error occurred, please get in touch with us.

New to Cadac Group?

  • The best prices Discover your personal price after creating an account
  • Buy or extend your Autodesk products Buy or extend your Autodesk products
  • Clear and easy to use webshop Clear and easy to use webshop
Need help? Service & Support

Password has been reset

Your password has been successfully changed. From now on, you will be able to log in with your new password.

New to Cadac Group?

  • The best prices Discover your personal price after creating an account
  • Buy or extend your Autodesk products Buy or extend your Autodesk products
  • Clear and easy to use webshop Clear and easy to use webshop
Need help? Service & Support