Facing challenges in setup of SCCM with SQL clustering

Mohd Atif Husain 80

Hi Team,

We are trying to setup a new site with SQL clustered on 4 nodes. During the setup on the database information wizard, we are putting up the SQL cluster followed by the dynamic port number which works fine. However, it is unable to copy the backup file to other nodes in the cluster. After, looking into the MS article related to configuration https://learn.microsoft.com/en-us/mem/configmgr/core/servers/deploy/configure/configure-aoag it looks related to when you have already remote SQL, and you are trying to convert or migrate to SQL Clustering.
Under this article, https://learn.microsoft.com/en-us/mem/configmgr/core/servers/deploy/configure/use-a-sql-server-cluster-for-the-site-database#bkmk_prepare, it says in the end about Installing a new site using cluster but didn't have given the steps to configure the same.
I am sharing the logs for the reference, here you can see it is backup the file at network location but the moment it tries to connect with other nodes to copy the same in the cluster it keeps on saying is not ready. What could be the possible cause of it? Also, looking here for a complete configuration article from MS which define the steps on configuration of SCCM with SQL cluster. Please help. Appreciate a quicker response here.

logs for sql clustering failing during setup User's image

Mohd Atif Husain 80 Reputation points

2024-04-15T12:14:02.5533333+00:00

@Garth Jones Need your inputs here please. Need a Microsoft approach to setup a Primary site underneath CAS with SQL clustering. No reference I am getting it on MS article. This article only talks about standalone setup. But our setup is different scenario. Any suggestions please.
https://learn.microsoft.com/en-us/mem/configmgr/core/servers/deploy/configure/configure-aoag
Mohd Atif Husain 80 Reputation points

2024-04-15T12:43:52.9833333+00:00

@AllenLiu-MSFT Need your inputs here please. Need a Microsoft approach to setup a Primary site underneath CAS with SQL clustering. No reference I am getting it on MS article. This article only talks about standalone setup. But our setup is different scenario. Any suggestions please. https://learn.microsoft.com/en-us/mem/configmgr/core/servers/deploy/configure/configure-aoag
Mohd Atif Husain 80 Reputation points

2024-04-15T12:51:55.59+00:00

@Prajwal Desai [MVP] @Anoop C Nair MVP Enterprise Mobility Need your inputs here please. Need a Microsoft approach to setup a Primary site underneath CAS with SQL clustering. No reference I am getting it on MS article. This article only talks about standalone setup. But our setup is different scenario. Any suggestions please. https://learn.microsoft.com/en-us/mem/configmgr/core/servers/deploy/configure/configure-aoag
Garth Jones 1,351 Reputation points

2024-04-15T13:01:48.7+00:00

Having dynamic ports will cause problems. if you have as CAS and therefore over 150K devices, You should contact your TAM, this is not a question for forums.
Mohd Atif Husain 80 Reputation points

2024-04-15T17:09:42.4033333+00:00

@Garth Jones Thanks for your response. Problem is not CAS actually, we will eliminate CAS post the setup of New primary site with SQL AOAG. Just want to understand if there is only one way to first setup new primary site without AOAG then setup the always on availability will be configured. Correct me if this is correct.
Garth Jones 1,351 Reputation points

2024-04-15T18:17:52.33+00:00

I would never setup a CAS and another Primary site so that you can setup SQL AO.

I would just setup SQL AO on the existing Primary site.