Upgrade SCCM 2207 to SCCM 2309 and upgrade SQL 2017 to SQL 2022 on the SCCM Server

Question

Hi,

I want to upgrade the following application:

1. SCCM from 2207 to SCCM 2309
2. SQL Server 2017 to SQL Server 2022

At the time I have SCCM 2207 and SQL Server 2017 as following screenshots

SCCM Version

SQL Version

SQL Reporting Service

Before I upgrade my SCCM 2207 to 2309, I want to upgrade my SQL Server 2017 to SQL Server 2022.

1. Does SCCM 2207 support the SQL Server 2022?
2. Does SCCM 2309 support the SQL Server 2022?
3. Can I uprgade SCCM 2207 directly to 2309 without to install the Hotfix (KB151522495 and the SCCM 2211 and the SCCM 2303? (I dont have gpgrade my SCCM 2207 to above version before)
4. Should I upgrade SQL Server Reporting Services directly to SSR 2019 or SSR 2022? or Should uninstall first SSR 2017 and then install SSR 2019 or SSR 2022? Do I need upgrade SSR 2017 to SSR 2019/2022?
5. Is there step by step guide for upgrade SCCM 2207 to SCCM 2309?
6. Is there step by step guide for upgrade SQL server 2017 to SQL 2002 specify for SCCM Server?

Regards

Nick

Answer 1

Hi, @PerserPolis-1732

Thank you for posting in Microsoft Q&A forum.

1. SCCM 2207 does not support SQL Server 2022. SQL server 2022 is supported start with SCCM 2303. So we can upgrade SCCM first, and then upgrade SQL Server.
2. SCCM 2309 supports SQL Server 2022.
3. Yes, you can upgrade SCCM 2207 directly to 2309 without installing the required hotfixes and versions in between.
4. You can upgrade SQL Server Reporting Services directly to SSR 2022.
5. The checklist for installing update 2309:

https://learn.microsoft.com/en-us/mem/configmgr/core/servers/manage/checklist-for-installing-update-2309

Install in-console updates for Configuration Manager:

https://learn.microsoft.com/en-us/mem/configmgr/core/servers/manage/install-in-console-updates

Post-update checklist:

https://learn.microsoft.com/en-us/mem/configmgr/core/servers/manage/checklist-for-installing-update-2309#post-update-checklist

6.Upgrade SQL Server

https://learn.microsoft.com/en-us/mem/configmgr/core/servers/manage/upgrade-on-premises-infrastructure#upgrade-sql-server

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Add comment".

Answer 2

Hi,

I have upgraded successfully to SCCM 2309 and SQL 2019. But after Upgrading I saw on "Monitoring-->Site Status

The Management Point was red and the Size was "0" byte , it means my management point does not run.

the prerequisite check, the warning I have ignored

I tried to restart with the "Configuration Manager Service Manager" and I get the error

"Communication error"

I have remove the MP and add it again. But on IIS was my SM_MP , SMS_MP_MBAM, SMS_MP_TokenAuth and.. away

Regards

Answer 3

Hi, @PerserPolis-1732

Have we checked this article:

https://www.anoopcnair.com/sccm-upgrade-resulting-in-mp-issue/

Answer 4

Do you mean really, I have to uninstall many roles and install that again? What is that for solution?

What is Remove SMS Management? Management Point?

I don't want to do that on the production machine. I will now restore my SCCM Backup to other physically machine and try to upgrade from 2203 to 2309 and I can experiment there. But as I know the SCCM should have network and Internet. I cannot run two SCCM 2207 with same FQDN name or DNS name on the my environment.

do you have any idea how I can run two SCCM 2207 on the network area or different Network area without to have any issue with FQDN and DNS and IP Address?

Answer 5

???????????????????????????