Installation of SCCM Reporting Service Point role over SQL AOAG

Mohd Atif Husain 100 Reputation points
2024-04-22T11:10:44.3033333+00:00

Dear 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.

Microsoft Configuration Manager
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AllenLiu-MSFT 40,551 Reputation points Microsoft Vendor
    2024-04-23T01:46:35.7833333+00:00

    Hi, @Mohd Atif Husain

    Thank you for posting in Microsoft Q&A forum.

    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#changes-for-reporting

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Add comment".