Sometimes when attempting to uninstall SQL Server, “Setup Support Rules” performs a check and fails on “Restart Computer” with the following error;
“A computer restart is required. You must restart this computer before installing SQL Server”
So you restart your computer and try again, same error… Doh!
So now it turns out there is a bad registry entry, so if you have restarted your computer and there are actually no pending restart operations that you are aware of the do the following
- Leave the Setup Support Rules UI open if you are already in there
- Open Regedit
- Go to the following registry key”HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager”
- Delete the “PendingFileRenameOperations”
- Click “Re-Run” in Setup Support Rules launch the uninstall again
So now you will have passed the restart computer check and you can continue and get rid of that pesky old version of SQL Server.
Thanks a ton….Worked perfectly for me.
solved. Stupid soft crashing my brains
You are a genius!!!! This took hours for me.
Kevin
Hi jcrawfor74, Thank you so much for this post, it was brilliant. I find Microsoft so frustrating when one cannot even un-install one of their products without running into some bizarre error for which Microsoft provide no help whatsoever. Regards Trevor Farley (Australia)
Thanks for the info!! I and running vista and finding the “Pending… was a little different but it is now uninstalling SQL Server!! (I just searched for “Pending” in regedit and it found the right one.
Please Visit This Site. Follow The Steps
http://www.sqlcoffee.com/Troubleshooting051.htm
This worked! Thank you!
Works! Thanks
This fix and you are a godsend! I had 3 2008/2008R2 instances to uninstall on one server and it worked everytime!
Thanks!
Thanks a lot!!!
There is no such Pending file in my Registry but still I am getting same error, Please advise what to do?
This worked! Thank you so much for posting it.
thanks good job
There is no PendingFileRenameOperation is my directory. Please advice me what to do?
This is good solution i did and it works well
Thanks from me too – I never would have guessed this !
Your post just keeps on giving! Thanks for the help!
Still useful, cheers!
this didnt work for me. I had to remove SQL server from command line with the following
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\setup.exe /SkipRules=RebootRequiredCheck /ACTION=uninstall
Hopefully helps someone else. windows 8.1, SQL 2008R2
Thanks! It works!
Thanks! It works!
Thank you much sir/ma’am, it worked!!