Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 one availability database" in the Availablity Group. I saw somewhere PBIRS has two databases - main Report Server and the Report Server Temp db. Does it mean you have to have two AG in SQL? Does this cause an issue or would we have to use Enterprise version of Always-On?
Thanks in advanced.
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
15 | |
9 | |
6 | |
3 | |
3 |