Installation of SCCM Reporting Service Point role over SQL AOAG

Mohd Atif Husain 170 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 No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AllenLiu-MSFT 45,156 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".


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.