Support

SQL - SQL Server Failure - Reboot Pending

Problem

SQL server installation fails due to a pending reboot.

Cause

There can be files that require renaming prior to another application being installed or updated. When this happens, the Windows machine enters the details of the changes required into the registry.

Then SQL launches, it checks this registry location to ensure that there are no reboots being required before installing.  If there are, it reports as a failure and requests that you reboot before installation can proceed.

Resolution

1. Run regedit
2. Navigate to HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Control\\Session Manager\\PendingFileRenameOperations
3. Rename the PendingFileRenameOperations key to "PendingFIleRenameOperations_Old"
   1. You may also have to do this with the remaining Current Control Sets as well such as: "HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet001\\Control\\Session Manager\\PendingFileRenameOperations"
   2. "HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet002\\Control\\Session Manager\\PendingFileRenameOperations"
4. Click re-run in the SQL Server 2008 installer or Service pack installer
5. Rename PendingFileRenameOperations_Old to PendingFileRenameOperations

Created: 6 Jun 2013 13:35 BST Updated: 22 Jul 2015 12:15 BST

Back