Sample Header Ad - 728x90

Setting up Availability group for report server databases

2 votes
2 answers
1682 views
I am reading msdn article on using SSRS with AG and have few doubts on setting up the same: - **Server A** - Will host Report Server services with scale out deployment - **Server N1** - Node 1 with ReportServer and ReportServerTempdb database serving as primary replica - **Server N2** - Node 2 is secondary replica of the ReportServer and ReportServerTempdb Above nodes will be part of multi-subnet cluster with N1 in DC1 and N2 in DC2. I am thinking to create the listener first with 2 IPs for those multi-subnet so that we can use same while installing reporting services and point the listener name in instance and it's report server database to it so that it is aware of primary replica even after fail-over. Is my above understanding correct? Is that how it's suppose to work? Secondly, document says automatic fail-over is not supported even when I use sync mode between N1 and N2? Is that true? And why would that be the case only with SSRS? Also if it is, can we automate the fail-over or does it have to be manual every-time since I am thinking data source application string can use the option MultiSubnetFailover=true ? Appreciate your inputs.
Asked by BeginnerDBA (2230 rep)
Feb 3, 2020, 03:37 PM
Last activity: Feb 4, 2020, 06:49 AM