SSRS Data Driven Subscription Option Not Appearing

1
votes

We have a new 2016 report server. It is supposedly the Enterprise Edition but Data Driven Subscriptions are not available in our PROD database but they are available in our TEST server.

I know that versions lower than the Enterprise Edition do not have Data Driven Subscriptions but our Operations department says that the servers are set up the same.

Unfortunately, I do not have access to check out the server edition (or much else) myself so I can't say for sure that the PROD server is the Enterprise Edition. Our Ops guys haven't done much with SSRS - I had to tell one guy where to set up the e-mail server so the e-mail Destination appeared.

TEST SERVER with data driven subscription:

enter image description here

Is there any reason, other than not having the Enterprise Edition, that could make the Data Driven subscriptions to not appear? Is there a setting or an option that needs to be checked during installation?

1
reporting-servicesssrs-2012
are you able to do a simple Select @@version in SQL Management Studio against your prod environment and compare it to your test environment.. that should tell you what version straight away.. or connect to the reporting server instance and then look at server properties.. Edition - Harry
Thanks @Harry - I was able to get a DBA to run it on PROD and it is the Standard version while our DEV server has the Developers Edition (ugh). That's what I suspected but didn't know if there are other reasons that the Data Driven subscriptions might not be available. - Hannover Fist
Glad to be of help.. I'll put my comment up as an answer - Harry

1 Answers

1
votes

There is no setting (as far as I am aware) that would disable the Data Driven Subscription option from appearing on your subscription window by default.

Simple Select @@version in SQL Management Studio against your prod environment and compare it to your test environment.. that should tell you what version straight away.. or connect to the reporting server instance and then look at server properties.. Edition., It's got to be the version!