Installation of SQL reposting services Point over SQL AOAG

Question

Hi Team,

Does SQL AOAG support installation of SCCM Reporting Services point role with listener details?

Or can we install the reporting services point without SQL AOAG and then later configure AOAG? Would that break anything with SCCM to SQL reporting?

Please suggest the best practice here.

Regards,

Muhammad Adeeb

Answer 1

Hi,

The reporting services point doesn't support using the listener virtual name of the availability group. It also doesn't support hosting its database in an availability group.

https://learn.microsoft.com/en-us/mem/configmgr/core/servers/deploy/configure/sql-server-alwayson-for-a-highly-available-site-database#install-the-reporting-service-point