I have two SQL Server 2019 machines in two different DCs.
Server Names: SQLDC1 and SQLDC2
Listener Name: SQLDC12
I want to install SSRS and Setup always on Availability group.
I did the following:
Install SSRS on server SQLDC1 and configure Reporting Services.
I used SQLDC12 Listener when configuring the SSRS dbs
I get the SSRS url from the above "http:/SQLDC1:80/Reports"
Changed the ReportServer and ReportServerTempDB dbs recovery model to full
Setup Availability Group between the SQLDC1 and SQLDC2
Now I am little confused.
Do I need to install the SSRS on SQLDC2 and configure Reporting Services using the SQLDC12 Listener when configuring the SSRS dbs?
If I do this then I will get the SSRS url similar to this "http:/SQLDC2:80/Reports", so how the url works when failover happens.
I see the SSRS installation with AlwaysOn on SQLShack.com but there author was using separate server for ssrs with two DB servers ( total three). In my case I have only two servers.
Please guide me further.
