SCCM/MECM Act-Passive supported SQL Backend setup

Cosmic Storm 21 Reputation points
2020-09-02T04:43:33.997+00:00

If we have to deploy SCCM/MECM Active/Passive servers, is it mandatory to have a SQL backend setup configured as "Always ON Availability Group" or will it even work with either a SQL "Fail-over Cluster" or a SQL "standalone" server?

Microsoft Configuration Manager
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Jörgen Nilsson 181 Reputation points MVP
    2020-09-02T05:26:20.323+00:00

    Hi, It will work just fine, there are no requirements to use either or, it is up to you which availability you are looking for.
    Regards,
    Jörgen


  2. Simon Ren-MSFT 13,226 Reputation points Microsoft Employee
    2020-09-03T10:58:15.91+00:00

    Hi,

    Thank you for coming Microsoft Q&A forum.

    The following SQL Server configurations can be used to host the site database:

    1.The default instance of SQL Server
    2.A named instance on a single computer running SQL Server
    3.A named instance on a clustered instance of SQL Server
    4.A SQL Server AlwaysOn availability group (beginning with version 1602 of Configuration Manager)

    For more information, please refer to:
    Plan for the site database for Configuration Manager
    Supported SQL Server versions for Configuration Manager

    Thanks for your time.

    Best regards,
    Simon
    If the response is helpful, please click "Accept Answer" and upvote it.