…. after installing SQL Server 2008 Express, put the value (might be multiple lines) back into this setting. So copy them somewhere!
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager is the path.
Session Manager is the folder.
PendingFileRenameOperations is the setting. Clear the value in that setting.
You’ll notice that there are more folders under the
Session Manager folder. Don’t look there. Those are sub-folders. Once you’ve clicked on the
Session Manager folder, find the setting on the right.
I’ve tried SkipRules option from another answer with SQL Server Express 2014:
SQLEXPRWT_x86_ENU.exejust to extract files then close it
setup.exe /ACTION=INSTALL /X86 /SkipRules=RebootRequiredCheck
Then the setup process didn’t complain on “Reboot required” rule but still failed at the end with the following messages:
A previous installation required a reboot of the machine for changes
to take effect. To proceed, restart your computer and then run Setup
One or more affected files have operations pending. You must restart
your computer after the setup process is completed.
Then I tried to temporarily delete both registry keys
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\PendingFileRenameOperations and
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\RebootRequired mentioned in other answers here.
After that setup run smoothly and everything worked without reboot.
like stated in http://blogs.msdn.com/b/hansr/archive/2006/02/17/patchreboot.aspx
there is also an important key from windowsupdate
this must also be 0 or not present.
When the tricks with clearing the registry keys don’t work:
– HKLM\SYSTEM\CurrentControlSet\Control\Session Manager\PendingFileRenameOperations
– HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\RebootRequired
You might try a reboot from the command line.
Press Windows+R for the “Run” dialog box and type cmd and press enter to start the command line.
The command for a forced reboot with zero seconds delay is “shutdown -r -f -t 0“.
This might be handy when you use a Windows 8 computer or a Win8.1 because a shutdown is sometimes not a real shutdown but a “hybrid shutdown” which is in fact a hibernate state to enable “Fast Boot”.
Windows -> Control Panel -> Administrative Tools -> Services and stop all of the
SQL Server Services. Then just hit
Maybe there’s a better solution, but the only one I could find was re-installing. Mental note: always install SQL Server first.
I had the same issue. when I restarted the machine it was working fine.it was due to windows updates in pending.
Step 1: Open the registry. For open registry, press window key + R and type
Step 2: Type regedit and press enter button
Step 3: Now selectHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager
Step 4: Double click “PendingFileRenameOperations”
Step 5: Delete all data from Value data textbox.
Step 6: Press OK and close the registry.
Now try to run SQL Server 2008 setup again. I hope Restart computer failed error not come again.