Related Pages

RSS Feed Knowledge Base Feed

Page Options

Unable to install SQL Server 2008 or SQL 2008 SP a restart is required

Problem Description:

 Attempting to install SQL Server 2008, or SQL Server 2008 Service pack 1 (SP1) you are told that you need to restart the computer in the prerequisites. You restart the computer but receive the same message that a restart is needed. Shutting down the system fully, or performing a full virus scan still leaves the issue behind.


Cause of the Problem:

 Some programs, notably Logitech webcams will leave behind a file rename operation registry key even though the operation completes.

The Microsoft SQL Server software checks to make sure no other installations or renames are pending, and checks this registry key.

Normally the key would get cleared after a restart, however the faulty software (again usually a logitech Webcam) will put the entry back in.

Your Ad Here


 The solution is to remove the registry key in question and then re-run the requirements check in the SQL server 2008 installer, or the 2008 service pack (SP1) installer.

  1. Click on start, and then run.
  2. Type in regedit and press enter
  3. Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\PendingFileRenameOperations
  4. You can either rename or delete the PendingFileRenameOperations key. We suggest renaming it to "PendingFIleRenameOperations_Old"
  5. 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" and "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet002\Control\Session Manager\PendingFileRenameOperations"
  6. Click re-run in the SQL Server 2008 installer or Service pack installer.

Once the installation is complete restart the computer


Related Programs and Devices:
Microsoft SQL Server 2008 , Windows 2008 Server , Windows XP , Windows 2003 Server , Windows Vista , Windows 7

Last Updated: 01/21/2010 01:17 PM

blog comments powered by Disqus