Microsoft SQL Server 2017 Web Edition & Reporting Services 2017 Developer Edition error
Dear Community, I've setup a Microsoft SQL Server 2017 Web Edition and downloaded afterwards the Reporting Services 2017, because its no longer included in SQL Installation directly. During the setup of the Reporting Service 2017 Installation I had to choose the Edition and my choice was also there "Developer Edition". Now when I try to configure the Reporting Service I run into the following error message: "The feature: "Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of Reporting Services." I added a print screen with the details. Does someone knows something about this error under Microsoft SQL Server 2017? Looking forward to every useful hint or input. Thanks and kind regards, Joël
How to increase timeout period for SharePoint SSRS report subscriptions
Hi All, We have SSRS 2016 environment in SharePoint 2016 integrated mode. I observed there are some subscriptions which are taking longer time than expected, though not generating report (may be due to timeout), is there any way we can increase timeout period for subscriptions (not report processing time), if yes 1. Should we increase timeout for whole environment or just for affected subscriptions? 2. As per my understanding, by design subscriptions are processed sequentially not parallel so we don't have any control on subscription processing, any suggestions here if we can control it programatically? 3. We already automated the SQL queries but there are some subscriptions pulling data for long period (6-7 years), what can be done in this case to make subscriptions run? We have only couple of Datasets and no caching plan setup as of now. Any comments or suggestions would be greatly appreciated. Thanks in advance!!!
