multisubnetfailover for repository DB

[nasr_hf]

Dear All,

We have a HA in -prem PBIRS setup with the repository configured using  LSN.

My problem is I am getting this error 

An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.

When I do simple nslookup for the LSN then I am getting two different IPs, when pointed out they asked me to configure 

multisubnetfailover=true.

My question is how to configure this for a PBIRS repository. I could find some help for doing it in Desktop.

TIA

[nasr_hf]

Dear Henry,

Thanks for your reply. I am not able find the options to set multisubnetfailover=true..

Kindly help.

TIA

[v-henryk-mstf]

Hi @nasr_hf ,

I recommend that you use the Report Services Configuration Manager to recreate the Report Server Catalog database. In addition, make sure that the Report Server instance can connect to the Report Server database.
For more information on configuring the Report Server database connection (SSRS Configuration Manager), refer to the following documentation.

Configure a Report Server Database Connection (Configuration Manager) - SQL Server Reporting Service...

In addition, you can also refer to the following related solutions.

ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An e...

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.