SOLVED SCCM HA configuration with SQL 2019 STD.

[Rohit]

Hello All,

I have installed MECM 2006 primary site server with SQL 2019 std version on the same server. My client wants to configure HA for MECM. Is it possible to configure HA with SQL std 2019 and SQL and Primary site server on the same server ??? Please suggest.

Thanks,
Rohit

 

[Youssef Saad]

Hi @Rohit,

The benefit of ConfigMgr HA is to keep using the service when the active site server is down. I would suggest to you to make the CMDB on a separate Always ON SQL. For more details:

• High availability options for Configuration Manager

 

[Rohit]

Can we use SQL 2019 Std for HA ???

 

[Youssef Saad]

If you are planing to configure a Always On Availability Group, you must have Enterprise edition.

Others HA supported scenarios are described in the following official doc:

• HA for SQL Server 2019

 

[Rohit]

Thanks, Youssef for providing the URL it was helpful. You can mark this thread as resolved.

Rohit

 

[Youssef Saad]

Glad to hear that. Good luck!

 

[Adsl Jalawiah]

If you are planing to configure a Always On Availability Group, you must have Enterprise edition.

Others HA supported scenarios are described in the following official doc:

• HA for SQL Server 2019

Hi Youssef, Not related to SCCM. It is about WFCS. What will happen if the domian admin account used to create a WFCS for SQL Server Always on is deleted. Will if affect the cluster operation? Should we create a separate Cluster Admin account ? Please reply