At present, I am running Windows Vista Ultimate as OS in my computer. I have installed SQL Server 2008 developer’s version in my computer.
A couple of months back, I learnt that SQL Server Book On-Line (BOL) update has been released. I usually depend on my Windows Update of SQL Server to install all updates in my OS, so I do not have to bother myself with installing updates manually.
However, this time I was quite taken aback to find that my computer was not updated with the latest updates released by Microsoft. Further, I noticed that my SQL Server Book On-Line is not up to date. This experience was nerve-wracking, as I expected my computer to have all the latest updates. I probed into the matter and found that there was an issue with some previous incomplete updates available with Windows Update. I was getting vexed with the following error every time I tried to run Windows Update.
Windows Update; Error Code 8000FFFF
I attempted to reboot, uninstall antivirus but had no luck fixing this error. I finally sent out an email to my friend who is expert in troubleshooting OS issues. He sent me some steps to resolve the issue.
After I performed the following steps, windows updated started to work normally and I was able to successfully download all SQL Server related updates.
- Click on Windows button and search ‘regedit’.
- Right click on the regedit and “Run as Administrator” (See Image 1).
- Go to HKEY_LOCAL_MACHINE >> COMPONENTS and look for keys described in steps 4, 5 and 6. In the absence of any key go to the next step (See Image 2).
- Find key PendingXmlIdentifier and delete it.
- Find key NextQueueEntryIndex and delete it.
- Find key AdvancedInstallersNeedResolving and delete it.
- Restart the computer.
- Once restarted now attempt Windows Updates; it should work fine now.
Do let me know if this solution helps you.
Reference : Pinal Dave (https://blog.sqlauthority.com)