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 Failed

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 Servicing Status. Now right click Configuration Manager 1810 and click Retry Installation.

SCCM 1810 Prerequisite Check Failed

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 Failed

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.

  1.  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.
  2. 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.

SCCM 1810 Prerequisite Check Failed

You might also like

37
Leave a Reply

16 Comment threads
21 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
newest oldest most voted
Shaun

Hi Prajwal, I love all your tutorials and they have saved me some headaches plenty of times. I am trying to upgrade to 1810 but it keeps failing in the prereq phase. It fails on the “SQL Server service running account” “SQL Server sysadmin rights” “SQL Server Configuration for site upgrade” “Max text repl size for SQL Server always on availability group.” My primary and my SQL server are separate. I verified that I have the account I am using has admin rights on both servers and I registered the SPN for both SQL servers. I am at a lost… Read more »

Cory

Hello Prajwal, thank you for all of your articles on SCCM – I knew nothing about the program when we implemented it and your guides have helped me out a lot. I just ran the prerequisite check to update to 1810 and am getting the “site database has a backlog of SQL change tracking data” warning. When I run the commands from the Microsoft Article, I find that my oldest entry is 89 days. When I run the cleanup, it appears to execute successfully but doesn’t seem to actually clean anything up. Running the prerequisite check after this still gives… Read more »

Nicole

I’m hoping someone can point me in the right direction. I’m trying to upgrade to 1810 but received the error below. I’ve changed my port but find no place to correct it and running client setup fails. The only successful option is to recover/reset site which I definitely want to avoid. Any suggestions?  ERROR: SQL static TCP port is not set.  ERROR: SQL dynamic TCP port is set to: .  [oursqlserver.fqdn.com]; SQL Server Tcp Port; Error; Configuration Manager primary site and central administration site require SQL Server Tcp is enabled and set to Static port. Thanks in… Read more »

Hatem Sobhy

Prajwal thanks for your usual support I had a problem in upgrading 1810 prerequisite check failed with error “SQL server configuration for site upgrade ” please advice

Andresp

I got also Pending Restart issue – restarting server(s) didnt resolved it. Checked registry items – clear.
Did Shutdown -poweron ( it is VmWare VM) . and after it readines checker goes green.
So – there is something more somewhere.

Luke

TLS 1.2 points to SQL 2012 and lower, I have SQL 2016 but I am still getting this warning which is odd

Ryan

Had the restart pending problem even after rebooting several times.

What fixed it for me was going into the registry and taking ownership of:
HKLM:SoftwareMicrosoftWindowsCurrentVersionComponent Based ServicingRebootPending
Gave myself permission to the registry key and deleted it.

Dont reboot. Run the install again.

Mantikor

Big thanks, Ryan. It helped.

Bruce

I’m getting sql server configuration for site upgrade fails sccm 2016

Ryan

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… Read more »

HERR WEILER

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

John Rehill

There’s now a missing step with making this connection. You don’t do it directly from entering SSMS. You first open SSMS, connect to the database and then use the ‘Database Engine Query’ icon to connect to the admin: instance and then you can run the queries

Cory

You probably have already figured this out, but for others who come across this – you must close the initial “Connect to Server” authentication box when you open SSMS. Then, from the bar at the top to the right of “New Query” open a Database Engine Query. This will open a new authentication window, but it will allow you to login to a DAC connection.

Daniel

One thing I would add as a reminder — If you have separate SQL Database / Primary Site servers, you need to update the Native Client on the Site Server, not just the SQL server.

Wpayton

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

Bob Bilek

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.

Greg Hoyle

Probably also worth noting that the Pending Restart prereq needs to be fulfilled on all Site Servers in the Site; so do check if your SQL DB or remote site servers need a reboot as well.

@

can you show step by step how to get rid of that warning about sql backlog?
doesnt seem to work for me:(

Aldin

Doesn’t work for me neither.
I’ve executed the command from the KB. No errors. All seems fine. But I still get the same warning.

mikey090tx

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.

Have you come across situations like this in the past?

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. AcceptRead More