question

HafeezUddin-8965 avatar image
0 Votes"
HafeezUddin-8965 asked Joyzhao-MSFT answered

SSRS installation on 2 node AlwasyOn cluster

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:

  1. Install SSRS on server SQLDC1 and configure Reporting Services.

  2. I used SQLDC12 Listener when configuring the SSRS dbs

  3. I get the SSRS url from the above "http:/SQLDC1:80/Reports"

  4. Changed the ReportServer and ReportServerTempDB dbs recovery model to full

  5. 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.

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered

Hi @HafeezUddin-8965 ,
What are your real needs? If you are only used for failover, you could configure a Native Mode Report Server Scale-Out Deployment instead of setting up an availability group.

When you click Scale-out Deployment to open the Scale-out Deployment page. You should see two entries, one for each report server instance that is connected to the report server database. The first report server instance should be joined. The second report server should be "Waiting to join".
128215-01.jpg
For more information, please refer to: Configure a Native Mode Report Server Scale-Out Deployment.
Best Regards,
Joy


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.


01.jpg (12.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LeonLaude avatar image
0 Votes"
LeonLaude answered LeonLaude commented

Hi @HafeezUddin-8965,

You may refer to the official Microsoft documentation over here:

Reporting Services with Always On Availability Groups (SQL Server)
https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/reporting-services-with-always-on-availability-groups-sql-server?view=sql-server-ver15


If the reply was helpful please don't forget to upvote and/or accept as answer, thank you!


Best regards,
Leon

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@LeonLaude
Thank you for your response.
I read the documentation you mentioned above and it was not clear about SSRS installation or I didn't get it.
I really appreciate if you can comment on my questions.

0 Votes 0 ·

As far as I know the Reporting URL will not be changed to the Listener, so it will stay as the server where you installed the Reporting Services.
The SQLHack guide which you mentioned provided quite a good in-depth step-by-step guide for this.

You will not need to install the SSRS on both cluster nodes, you install the SSRS databases on the SQL instance that works as a primary replica.


0 Votes 0 ·