Good day everyone,
Fate has dealt me another oddity, I'm hoping someone out there has conquered this before.
I have a Windows Server 2012 R2 that I need to upgrade the SQL server from 2008 to 2016. When I go to do the installation, I'm getting stymied at the pre-check assessment because the installer is detecting the server has a windows update waiting for the computer to restart.
So first time around, went into the control panel, went to updates, hit restart now. Watched as the typical server restart messages come up but noticed there was no message about the updates progression. Nor when it started back up.
So tried the SQL upgrade again, same result.
So I checked the updates window again, still show restart now. Looked at view update history and found three updates were showing pending restart.
KB4284815
KB4099635
KB4103725
Off the top of my head 4284815 and 4103725 were both just security rollup updates.
I so I looked under view details on each update and found error 80242014 on each one. So my next thought was to uninstall these specific updates. They uninstalled successfully, did the restart but still found the pending restart getting in the way of the SQL upgrade. I came across a few posts that said people reinstalled those updates afterwards and the restart pending went away.... but not for this guy.
Also tried a few more things I had found in suggestions, such as:
-Running the windows update diagnostic tool.
-Stopping the Windows update and BITS services and cleaning out the contents of Softwaredistribution folder.
-resetting the windows update service.
-deleting the entries in the registry for pendingfilerenames
-deleting the pending.xml file (didn't exist in my case)
- I even reuninstalled those updates and tried the July security rollup kb4507463 and found it too gets the same issue.
SFC shows no errors.
So I'm a bit stumped on what to try next
Fate has dealt me another oddity, I'm hoping someone out there has conquered this before.
I have a Windows Server 2012 R2 that I need to upgrade the SQL server from 2008 to 2016. When I go to do the installation, I'm getting stymied at the pre-check assessment because the installer is detecting the server has a windows update waiting for the computer to restart.
So first time around, went into the control panel, went to updates, hit restart now. Watched as the typical server restart messages come up but noticed there was no message about the updates progression. Nor when it started back up.
So tried the SQL upgrade again, same result.
So I checked the updates window again, still show restart now. Looked at view update history and found three updates were showing pending restart.
KB4284815
KB4099635
KB4103725
Off the top of my head 4284815 and 4103725 were both just security rollup updates.
I so I looked under view details on each update and found error 80242014 on each one. So my next thought was to uninstall these specific updates. They uninstalled successfully, did the restart but still found the pending restart getting in the way of the SQL upgrade. I came across a few posts that said people reinstalled those updates afterwards and the restart pending went away.... but not for this guy.
Also tried a few more things I had found in suggestions, such as:
-Running the windows update diagnostic tool.
-Stopping the Windows update and BITS services and cleaning out the contents of Softwaredistribution folder.
-resetting the windows update service.
-deleting the entries in the registry for pendingfilerenames
-deleting the pending.xml file (didn't exist in my case)
- I even reuninstalled those updates and tried the July security rollup kb4507463 and found it too gets the same issue.
SFC shows no errors.
So I'm a bit stumped on what to try next