SCCM 1810 Prerequisite Check Failed – Fix for Error and Warnings

In my previous post, I covered the steps to perform SCCM 1810 upgrade. In that post I mentioned that i encountered an error and few warnings. While I was installing the SCCM 1810 update, I encountered an error during prerequisite check. This is the first time i got stuck at prerequisite check step.

In my lab setup, I saw that my SCCM 1810 prerequisite check failed. I immediately checked the update pack installation status and i saw the error Pending System Restart. This is the first I saw this message since many years. To continue with the update installation, I had to skip the prerequisite check (ignore those warnings) and directly install the update pack.

However along with Pending system restart error, I also saw two other warnings that were related to SQL server. If you read this article on what’s new in SCCM 1810, it is mentioned that prerequisite check is now more resilient. It checks additional registry keys for Windows features. The error pending system restart can be fixed by simply restarting the server (at-least in my case that fixed it). If the restart didn’t fix that error for you, let me know in comments section.

Here are the SQL warnings that i got during SCCM 1810 prerequisite check.

[Completed with warning]: Verifies that the version of Microsoft SQL Server Native Client installed on the site server meets the minimum requirements to enable TLS 1.2 support.
[Completed with warning]: The site database has a backlog of SQL change tracking data.

SCCM 1810 Prerequisite Check – Pending System Restart

If you are installing SCCM 1810 and if you see SCCM 1810 prerequisite check failed with pending system restart, here is what you should do.

If you see pending system restart error, you should know that the update installation will not happen. So first of all go ahead and restart the server. Post the restart, launch the SCCM console. Go to Monitoring > Overview > Updates and ServicingStatus. Now right click Configuration Manager 1810 and click Retry Installation.

You will now see a dialog box “To install the update pack again, click OK”. Click OK to install the update pack. The update should now be installed without any issues.

SCCM 1810 Prerequisite Check – SQL Server Warnings

In the beginning of the post, I talked about those two SQL Server warnings that I got during SCCM 1810 prerequisite check. Let’s see what those warnings mean and how to fix those warnings.

The site database has a backlog of SQL change tracking data – If you see this warning then let me tell you that a new check has been added to prerequisite check step. It checks if the site database has a backlog of SQL change tracking data. To fix this warning, refer this article.

Microsoft SQL Server Native Client on the site server meets the minimum requirements to enable TLS 1.2 support. If you check the ConfigMgrPrereq.log file, you will find this line. SQL Server Native Client version – Warning. Configuration Manager sites require a supported SQL Server Native Client version. To enable TLS 1.2 support, you must install a supported version of SQL Server Native Client on the specified site database server. To fix this you need to update the SQL Server Native Client to fully support TLS 1.2. Once updated, the warning should disappear. Click this link for more info on TLS 1.2 support for Microsoft SQL Server. Hope this post helps.

I had the SQL Native 2012 Client and Reboot prerequisite failures for 1810. Updated the Native client and that cleared, then rebooted a half dozen times but no luck getting the Restart pre-failure to clear.

It would not let me proceed or ignore to bypass and install.

I am running a standalone SCCM server with local SQL on a 2016 Hyper-V VM. The Host is running 2012 R2.

I loaded Hyper-V manager and ran a shutdown (Not a restart but a shutdown) of the VM and saw a “Getting Windows Ready Do Not Power Off” message? What? I thought this was it and that the error would clear but I was wrong. Subsequent restarts showed the “Getting Windows Ready” again so I scoured the Event viewer to see if there were any pending updates. Everything was clear.

After a few hours of waiting/retrying I noticed the “Getting Windows Ready” message was gone when rebooting. Ran the PreRequ scan and PASSED!

I checked Windows Update and the last update installed was KB4483229. Is it possible this was still running/finishing in the background? Probably.

Thanks for the update Ryan. I know that error is irritating. You may be right, if the update is not installed or needs a reboot to complete it’s installation, the SCCM still shows pending restart message. Microsoft doesn’t clearly say what checks are actually done that determines and alarms pending system restart message.

Hello Prajwal, thanks for your research. Unfortunately I am not able to establish the admin connection via SQL Management Studio 2014. If I try to connect via SSMS to ADMIN:SCCMSERVERNAME, the (translated) error message reads like “Dedicated admin connections via SSMS are not supported, because programmatically multiple connections are established…” Any idea how to establish this connection via SSMS? Unfortunately, in the Microsoft article there is no detailed description. Thank you in advance, best wishes from Germany, Markus

Pending restart is still failing after tons of reboots. How can we force the install. Everything else passes. I also checked all the registry keys that would signal file rename ops etc…… This is frustrating

I’ve restarted my site server, but the prereq check is still failing saying a system restart is pending. I’ve already updated my Windows 10 ADK and installed the updated SQL native client. I’ve probably restarted the server a total of 3 times now. No windows updates are pending.

Prajwal- Great walkthrough. I was able to update to 1810 and updated our ADK to ver10.1.17763.1 and distributed our boot images to all DP’s. Now when we Pxe a device, we are no longer presented with any of the task image options. I reviewed the smspxe log and I can see where the unknown device is initiating the pxe sequence but it is as if no task sequences are present or available.