Installation of SCCM Reporting Service Point role over SQL AOAG

Question

Installation of SCCM Reporting Service Point role over SQL AOAG

Anonymous

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.

1 answer

Your answer

Answer 1

AllenLiu-MSFT 49,436 Microsoft External Staff

Hi, @Anonymous

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

Anonymous

2024-04-23T05:47:44.6033333+00:00

Hi @AllenLiu-MSFT Thanks for sharing this article. I already had gone through it only thing is wanted to understand how we can install then Reporting services point role in such case. Do we need to use SQL primary replica server name instead of listener name? Please suggest.
AllenLiu-MSFT 49,436 Reputation points Microsoft External Staff

2024-04-23T08:55:02.4233333+00:00

Yes, like the article said, change this setting to specify a computer name and instance of a replica in the availability group.
Anonymous

2024-04-23T10:00:07.2833333+00:00

@AllenLiu-MSFT Thanks a lot your great help as always.
AllenLiu-MSFT 49,436 Reputation points Microsoft External Staff

2024-04-29T06:20:21.2933333+00:00

You're welcome. It's appreciated that you could click "Accept Answer" to the helpful reply.

Share via

Installation of SCCM Reporting Service Point role over SQL AOAG

1 answer

Your answer