Before installing the server Primary Site Server SQL database server needs to be prepared. The obvious question is the issue of service accounts used. When we look to the relevant article of the manufacturer[1] you will find that we actually have two options regarding service accounts:
However, it is known that SQL Server in modern versions can use a slightly different configuration, using gMSA (Group Managed Service Accounts).
Of course, it is tempting to check whether such a crafted SQL Server will be acceptable to Configuration Manager. To check, SQL Server was prepared using gMSA service accounts.
There is no doubt that a SQL server prepared this way can work properly, while freeing the administrator from the problem of service account password rotation. Running Configuration Manager's installation program will check whether it will accept such a database server configuration:
It turns out that during the installation SQL Server is accepted and SQL database created correctly. The installed Configuration Manager functions correctly.
Check in the logs left by the installation Configuration Manager Primary Site Confirms that the SQL database engine service account is accepted. The prerequisite check log passes the service account test without error.
The installation log directly recalls the account name, also reporting no errors or warnings.
[1] https://docs.microsoft.com/en-us/configmgr/core/plan-design/configs/support-for-sql-server-versions#sql-server-service