Share via

AG DB w/ SSRS

Alex Thompson 1 Reputation point
2021-08-23T20:19:01.513+00:00

Our company is needing to install MSSQL and SSRS to support a 3rd-party reporting application which leverages these tools. The installation instructions assume a single DB configuration, but as a business practice we replicate all our DBs tp support patching and DR. I've set up plenty of DBs with HA AG, and a long time back I did some SSRS installations, but it's been awhile, and never in an HA configuration. Can someone clue me in on how this topology might work? Do we put SSRS on both servers in AG, or does SSRS need to be installed on a 3rd server which then leverages the listener name for connection. I've ready over this doc, but it doesn't seem to address my questions, though it does indicate that there are limitations on how SSRS can work with HA MSSQL.

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,878 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,571 Reputation points
    2021-08-24T07:01:27.777+00:00

    Hi @Alex Thompson ,

    Do we put SSRS on both servers in AG, or does SSRS need to be installed on a 3rd server which then leverages the listener name for connection.

    No,you don't need do that. When you mainly add a database to SQL Server Always On Availability Groups, check "Full".
    For more information,please refer to: SQL Server Always On Availability Groups for Reporting services database.
    Step-By-Step: Creating a SQL Server Always On Availability Group
    Your issue is more database-related. I suggest that you choose to add "sql-server-general" to questions in this area, and more professional people will answer for you.
    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.

    0 comments