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
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jörgen Nilsson 186 Reputation points
    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 29,956 Reputation points Microsoft Vendor
    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.