How do I configure Reporting Services on an Always-On cluster?

Reilly, Todd 0 Reputation points
2024-03-19T15:03:11.46+00:00

I need to install Reporting Services on an Always-On cluster with two nodes. Setting up the database is not a problem. I create the database using the listener address and then set up the Always-On availability group for it on the primary and use Automatic Seeding to create and set up the database on the secondary. I don't know how to configure Reporting Services however if the Reporting Services application sits on an Always-On cluster. Is that even possible? When you install Reporting Services should you use the listener address instead of the node name?

Thanks.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,949 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Dirk Hondong 871 Reputation points
    2024-03-19T15:59:02.3933333+00:00
    0 comments No comments

  2. ZoeHui-MSFT 38,371 Reputation points
    2024-03-20T05:30:33.3366667+00:00

    Hi @Reilly, Todd,

    Please read of the documentation.

    Reporting Services with Always On Availability Groups (SQL Server)

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

  3. Olaf Helper 45,286 Reputation points
    2024-03-20T06:02:06.9566667+00:00

    As Dirk wrote, SSRS is not cluster aware.

    SSRS is mainly a web server and as with other web server you can setup a web farm = scale-out, see

    Add another report server to a farm (SSRS scale-out)

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.