Reporting Services with SQL Server Web edition 2019

Question

Hi,

Can anyone tell me whether it's possible to install SQL Server Reporting Services against SQL Server Web Edition?

From the documentation it sounds as though it is possible: https://learn.microsoft.com/en-us/sql/reporting-services/reporting-services-features-supported-by-the-editions-of-sql-server-2016?view=sql-server-ver15

However, when I try to install SSRS Web edition doesn't come up as an option. Also when I have extracted the SQL Server Web Edition product key and used that with the SSRS installation it is not accepted.

For context we are running a small web site which works fine with SQL Server Web edition but we do have an area where we generate reports.

Does anyone know if this is possible?

thanks

Answer 1

However, when I try to install SSRS Web edition doesn't come up as an option

That's in all editions so, because since version 2017 isn't longer part of SQL Server installation media, it comes as separate installer.
You can download SSRS from Microsoft SQL Server 2019 Reporting Services
To install it you need your MS SQL Server product key.

Answer 2

Hi @Hamish Buchanan ，

If you want to get the product key from the installed SQL Server ，please refer to: https://www.ryadel.com/en/sql-server-retrieve-product-key-from-an-existing-installation/

Hope it will help.

Best Regards,
Isabella

---

If the answer is the right solution, please click "Accept Answer" and 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.