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
SCCM/MECM Act-Passive supported SQL Backend setup
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?
2 answers
Sort by: Most helpful
-
Jörgen Nilsson 186 Reputation points
2020-09-02T05:26:20.323+00:00 -
Simon Ren-MSFT 34,171 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 ManagerThanks for your time.
Best regards,
Simon
If the response is helpful, please click "Accept Answer" and upvote it.