Forum Discussion

P3UAL's avatar
P3UAL
Frequent Visitor
8 years ago

PBIRS - High Availability "Basic"

Hi,   Does anyone know or have experience in running PBIRS on HA but using Always On Basic Availability Groups from SQL Standard license. I've read in "basic" one of the limitation is  "Support for...
PBIRS
SQL
Anonymous's avatar
Anonymous
Not applicable
8 years ago

You must put both database to the HA Group. See here

But you must ensure that all servers has the service credentials an the logins and you must restart the report server after every failover to ensure that the scheduled refreshs are working.

 

After you that use the standard edition, the limitation avoid this scenario:

https://docs.microsoft.com/de-de/sql/database-engine/availability-groups/windows/basic-availability-groups-always-on-availability-groups?view=sql-server-2017