Microsoft

System Center Configuration Manager Feedback

Suggestion box powered by UserVoice

How can we improve Configuration Manager?

Add support for hosting the ConfigMgr DB on a Basic Availability Group (Always On)

Always On Basic Availability Groups provide a high availability solution for SQL Server 2016 and SQL Server 2017 Standard Edition. A basic availability group supports a failover environment for a single database. It is created and managed much like traditional (advanced) Always On Availability Groups (SQL Server) with Enterprise Edition.

ConfigMgr now requires read access to secondary replicas, which is only available in the Enterprise Edition of SQL Server.

47 votes
Vote
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
You have left! (?) (thinking…)
Kenneth van Surksum shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

3 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Vladimir Zelenov commented  ·   ·  Flag as inappropriate

    SQL Server Standard Edition is a part of System Center license. Too many companies use ConfigMgr as non-business critical service and SQL Server Enterprise is expensive for it. Business don't want to pay this cost for HA and it starts to be a pain for system administrators.

  • Steve Thompson commented  ·   ·  Flag as inappropriate

    Now that SCCM HA is available, SQL Server Basic AOAG (Standard edition), is needed to provide SQL HA. For a client to implement SCCM HA, with SQL AOAG (SQL Enterprise), they would need THREE (3) new servers!

    If SCCM could support SQL AOAG (2 node basic - std edition) , the client would only need ONE (1) new server to have SCCM HA and SQL HA. Thanks for posting this Kenneth!

Feedback and Knowledge Base