TIP: Installing SQL Server 2008 – reboot required check fails

When installing SQL Server 2008 one can run into “‘Reboot required check failed” situation.

After seeing it few times already, I think a solution is worth mentioning.

“Why don’t you just reboot?”, you say… Well, most likely it would not help you, but try it first.
If this would not help, then try the following:

  1. Start regedit.exe
  2. Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager
  3. Locate PendingFileRenameOperations
  4. Remove any data associated with the value (you may want to export the value for later review)
  5. Reboot and rerun installation, check should pass.

Update. As a respond to some comments about solution above not always work you may consider the following:

  • Make sure that after you reboot entry in the registry does not reappear.
    If it does, remove it again, but do not reboot, just go ahead with installation process and click “ReRun”. Most likely you would be fine now.
  • You may also try and see that other ControlSet001, ControlSet002, etc do not suffer from the same problem (solution mentioned by Mike Hills below).
  • There was mentioning that some installations of Visual Studio 2008 could cause check to fail as well. So if nothing from above helped, uninstall Visual Studio (comes with light version of SQL Server), install SQL Server and then reinstall Visual Studio again.

Lets see why would entry reappear… This may happen if there is a driver or application which supports “recovery” mode or plain virus is around and after reboot it is trying to finish the deployment process again. In any situation try and look closer: what app file belongs to, if there are other solutions to the problem so that original process would finish properly, etc.

Update: Recently I was working on the unrelated setup automation for Visual Studio and stepped on a hidden gem which may work here as well: when running setup from command prompt, Windows Installer accepts a parameter called SkipRules. It worth mention the following “How to: Install SQL Server 2008 from the Command Prompt” first and then look at desired parameter

/SkipRules=VSShellInstalledRule RebootRequiredCheck

We can ignore first rule, since it is VS related, but second is the one you may want to try.

This entry was posted in Fun stuff with SQL Server and tagged , , , , , , . Bookmark the permalink.

31 thoughts on “TIP: Installing SQL Server 2008 – reboot required check fails”

  1. Pierre says:

    I had the same problem with the logitech garbage in the registery. Just want to add two minor clarification:
    1- I didn’t removed the PendingFileRenameOperations registery but only the content
    2- I didn’t rebooted after step 1 but I justed clicked on rescan in the SQL installation tool

  2. Dinesh Vishe says:

    Wow…GREAt help me……….Lot.Thanks

  3. Bull says:

    TeamViewer will cause this as well.

  4. Rich says:

    Good call. Mine was failing because of a user logged in over RDP who had printer redirection turned on. The reg key points to the culprit.

    Well done.

  5. Rob Hufschmitt says:

    Thank you very much!!
    Your solution helped me solving this problem:
    MS Dynamics 2011 Client could not install MS SQL Server 2008 Express and asked for a reboot continuously as described in this blogpost:

    Again Thank You!

  6. steve warner says:

    Brilliant. Solved my problem.
    Thanks much.

  7. Dmitry says:

    thanks a lot, “required” !
    There is no “PendingFileRenameOperations” in reg in Wind 10 TP …

  8. Nitesh Sahu says:

    thanks a lot…. this works 🙂

Leave a Reply

%d bloggers like this: