I need to install SSRS for report development and deployment. I don't work with it myself and I haven't had much luck trying to find the information I need. My boss would like me to install SSRS 2019 Enterprise Edition. It looks like there is just one download for SSRS 2019. Here are the questions I have.
- Since the reporting databases for SSRS 2019 Enterprise can be on either Enterprise of Standard Edition servers, how does SSRS know if it is Enterprise or Standard Edition?
- Does SSRS 2019 Enterprise Edition need to be installed on SQL Server 2019? I don't know if it's features are dependent on the database server or if they are just internal to SSRS.
Our situation is the following. If the SSRS 2019 features are internal and not dependent on the SQL Server version, we'd like to host the reporting services databases on one of our SQL Server 2017 Enterprise servers instead of installing a SQL Server 2019 Enterprise Edition server just to host reporting services database.
We've looked around trying to find these answers but despite a lot of MS's documentation getting a lot better, SSRS is still somewhat vague in their wording. I'd really like to not have to do this multiple times trying to get it right. Any help would be greatly appreciated.