How to add Reporting Services to an existing SQL Server 2019 Clustered Instance

Question

Hi All,

I have already set up my clustered environment and it is working fine. But now, there is a requirement came for reporting services for only one instance in that cluster.

So, I have tried to add "Reporting Service" using the "Add feature to the existing environment" option in setup. But we couldn't see Reporting Service on there.

So how I install and set up reporting service to the required instance.

Answer 1

"Add feature to the existing environment" option in setup. But we couldn't see Reporting Service on there

Since version 2017 SSRS comes as a separat installer, you can download it here: Microsoft SQL Server 2019 Reporting Services
You can use the same license key of database engine to install SSRS. Keep in mind, SSRS isn't cluster-aware application.

Answer 2

Hi @Chamali Liyanage

I will explain step by step how to add SSRS onto an existing clustered environment.
https://www.mssqltips.com/sqlservertip/2778/how-to-add-reporting-services-to-an-existing-sql-server-clustered-instance/

https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/install-reporting-services?view=sql-server-ver15

If the Answer is helpful, please click Accept Answer and up-vote, this can be beneficial to other community members.

Answer 3

Hi @Chamali Liyanage ,

Welcome to Microsoft Q&A!

SQL Server 2019 Reporting Services has a separate installation, please download it from this link. And you could refer to Install SQL Server Reporting Services to get more information about how to install it.

Best regards,
Carrin

---

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