question

AlexThompson-3423 avatar image
0 Votes"
AlexThompson-3423 asked Joyzhao-MSFT commented

AG DB w/ SSRS

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
· 1
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.

Hi @AlexThompson-3423 ,
Has your issue been resolved?
If you have any questions, please feel free to let me know.
If the answer is helpful, please click "Accept Answer" and upvote it.
Best Regards,
Joy

0 Votes 0 ·

1 Answer

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

Hi @AlexThompson-3423 ,

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.


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.