Enterprise Report Server not showing Data Driven Subscriptions

Question

We have updgraded from Standard to Enterprise reporting services. We were expecting to have the option to create data-driven subscriptions but the option is not available. All the articles found during our web search say 'Data-driven subscriptions' will just be available when you have an Enterprise license. We would appreciate help.

Answer 1

Hi @Linda，

Please have a double check that data source connection information used by the report to get data.

Only reports that use stored credentials to access a report data source can be distributed through a data-driven subscription. Stored credentials are necessary for unattended report processing.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Hi @Linda,

Thanks for your information.

but the option is not available

Please ensure you have the Content Manager permissions. You can follow the steps below to grant permission:

1. Open Reporting Services Configuration Manager.
2. Select the Report Manager URL tab.
3. In the Report Manager Site Identification section, select the URL to open Report Manager.
4. Select Manage.

Finally, this is an article explains how to create data-driven subscription in detail, you can check it out and follow the steps.

Hope this can help you well. Feel free to share your issue here.

Best regards,

Lucy Chen

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

https://docs.microsoft.com/en-us/answers/support/email-notifications

Answer 3

Hi @Linda,

Thanks for your feedback.

Please make sure you've correctly configured and deployed a report server.

As Zoe says, the data source should be configured to use stored credentials.

Only reports that use stored credentials to access a report data source can be distributed through a data-driven subscription. Stored credentials are necessary for unattended report processing.

In addition, here is a table describing the prerequisites must be met before you create a subscription to a report. Hope this can help you troubleshoot your issue.

Best regards,

Lucy Chen

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

https://docs.microsoft.com/en-us/answers/support/email-notifications

Answer 4

Hi @Linda,

Let's confirm that you are using enterprise version SSRS?

You may check via SSRS configuration manager. Only Enterprise and Developer edition can use DDS.

In addition, make sure of the data source of your report is using stored credentials.

If you still cannot see DDS, you may open a ticket for Microsoft if you already have paid for license to get directly help.

Services Hub (microsoft.com)