Comments on: Install SQL Server 2019 for ConfigMgr – Bonus Guide https://www.prajwaldesai.com/install-sql-server-2019-for-configmgr/ SCCM | ConfigMgr | Intune | Windows 11 | Azure Mon, 19 Dec 2022 16:35:29 +0000 hourly 1 https://wordpress.org/?v=6.4.1 By: Syed Abdul Basit https://www.prajwaldesai.com/install-sql-server-2019-for-configmgr/#comment-41283 https://www.prajwaldesai.com/?p=217518#comment-41283 Thanks for such a nice article, but while i was installing the sql server 2019 it gave me two more options, distributed replay controller and distributed replay controller. if you define them as well it will be great.

]]> By: MikeB https://www.prajwaldesai.com/install-sql-server-2019-for-configmgr/#comment-31691 https://www.prajwaldesai.com/?p=217518#comment-31691 What is problematic at the moment is trying to do a MECM install using the latest versions of the underlying products. That is a SQL Server 2019 fail-over 2 nodes using iSCSI cluster running on Windows Server 2022 and the Site Server also being on Windows Server 2022. You have to start with the last baseline ISO which is 2103 and you just can’t get past the SQL Errors during the setup.
One being an “unsupported site server operating system version for setup” against the SQL Server cluster, with the additional text of “Configuration Manager site systems can only be installed on computers running supported operating systems. ”
And the second one being “Primary FQDN” again against the SQL Server with additional text “Configuration Manager only supports the use of primary FQDN’s, where the DNS hostname (first label in the FQDN) matches the NetBIOS hostname of the computer. The FQDN provided for this site system does not meet this requirement and cannot be used. Correct the FQDN and try again.”
I realise there is a new CM coming later this year but the current product is supposed to work on the 2022 releases (as site servers)

]]> By: Tom Salvant https://www.prajwaldesai.com/install-sql-server-2019-for-configmgr/#comment-29580 https://www.prajwaldesai.com/?p=217518#comment-29580 Hello,
Thank you for all the info here. I installed/used SCCM back in the 2012R2 version.

In my scenario, I will have a separate primary site server and database server.

I know for the installation of MECM/SCCM, the account I will be logged in doing the installation of MECM (not the DB install, the actual product) with has to have SQL Server administrators access.

After that installation is done, can that service account be removed from the SQL Server administrators group and given less permissions to run the day-to-day operations in MECM? I am trying to find guidance on this but I am unable to locate that permissions set that would be necessary (the minimum permissions needed on the SQL side to still allow MECM to work.)

Do you know if that is possible or does the account need to remain as an administrator to the database (SA access)?

Thank you again for all the great posts and your help.

]]> By: FazzaGBR https://www.prajwaldesai.com/install-sql-server-2019-for-configmgr/#comment-27101 https://www.prajwaldesai.com/?p=217518#comment-27101 With regards to the CMADMIN account – on a production server what Active Directory Group should it be in – in a test environment we used Domain Admin but now we’re installing on a production server what security group in AD should it be in?

]]>