Facing challenge with configuration of SCCM with SQL AOAG

Muhammad Adeeb 0 Reputation points
2024-04-15T12:58:04.6833333+00:00

Hi Team,

We are looking here help for the best approach to configure and setup sccm with SQL AOAG. In our current infrastructure, we are adding a new Primary site with SQL AOAG underneath existin CAS. This article talks about https://learn.microsoft.com/en-us/mem/configmgr/core/servers/deploy/configure/configure-aoag the existing site with SQL AOAG but not with the new sites. However, we are looking for the step by step configuration of new primary site with SQL AOAG under the CAS. Just for information we have a plan to remove CAS in future.

Thanks & Regards,
Muhammad Adeeb

SCCM Admin

Microsoft Configuration Manager
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Githad19 40 Reputation points
    2024-04-16T16:24:02.94+00:00

    For new primary site with SQL AOAG under the CAS SQL, we need to create Availability Group Listener. When install system center configuration manager setup wizadd, type the name of Availability group listener into SQL server name.

  2. Garth Jones 1,351 Reputation points
    2024-04-17T11:59:26.1733333+00:00

    Since you have a CAS, and therefor over 150K devices, you should contact your TAM for support.