Not able to install SqlServer 2008 says Restart computer failed
While trying to install SqlServer2008 it show Restart computer as failed. I have restarted my computer and still it shows the same error. Cant proceed further. Please advice on how to proceed to install SqlServer 2008.
Thanks
Ashok
Answers
Check your system's pending file rename operations registry key. It should be cleared after you reboot your system. If not, something must be wrong.
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\PendingFileRenameOperations
- Proposed As Answer byJimmyAdkins Tuesday, May 12, 2009 7:53 PM
- Marked As Answer byJonathan KehayiasMVP, ModeratorThursday, October 01, 2009 3:48 PM
- I will say if you are getting stuck now, the best way is to uninstall everything.
And then,
Install SQL Server 2008 first since you want SQL Server 2008.
Install VS 2008 +SP1 second.
Since SQL Server 2008 is not released, installing SQL Server 2008 first is the easiest thing.
All Replies
You can uninstall SQL Server 2008 first.
Try to use this link for your reference.
http://msdn.microsoft.com/en-us/library/ms144259(SQL.100).aspx
Does symantec installed on your machine? dose the machine infected with KAVO virus?
Madhu
- Symantec Antivirus is installed in my system. But no known virus infection
Check your system's pending file rename operations registry key. It should be cleared after you reboot your system. If not, something must be wrong.
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\PendingFileRenameOperations
- Proposed As Answer byJimmyAdkins Tuesday, May 12, 2009 7:53 PM
- Marked As Answer byJonathan KehayiasMVP, ModeratorThursday, October 01, 2009 3:48 PM
- I have the same issue - i've checked the pending file operations, and there are none.
Also, the Link in the Setup (http://go.microsoft.com/fwlink/?LinkId=94001) leads to a Firewall configuration page that does not explain what the rule evaluates exactly. I am stuck at 'Previous release of Microsoft Visual Studio 2008' and the detail show that VS 2008 SP1 is missing, installed it and still can't proceed.
Any help is greatly appreciated.
Thanks
BMWAustin wrote: I am stuck at 'Previous release of Microsoft Visual Studio 2008' and the detail show that VS 2008 SP1 is missing, installed it and still can't proceed.
Any help is greatly appreciated.
Thanks
You'd want to install just the basic (i.e. db engine only).
http://support.microsoft.com/kb/956139
- I will say if you are getting stuck now, the best way is to uninstall everything.
And then,
Install SQL Server 2008 first since you want SQL Server 2008.
Install VS 2008 +SP1 second.
Since SQL Server 2008 is not released, installing SQL Server 2008 first is the easiest thing.
I have the same issue, but I've also found the culprit. After installing .NET Framework 3.5 SP1, Windows Update attempted to install a Hotfix KB953595. It is listed as installation was Successful, but it cannot be removed through Control Panel, and when I look for the installation package in \Windows\SoftwareDistribution\Downloads, there is no package for this Hotfix, so I can't figure out how to force it's uninstall.
There is also nothing listed as pending under
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\PendingFileRenameOperations
so I am at a loss as to how to uninstall a Hotfix that isn't there.
Nor have I been able to find the hotfix & download it & re-install it.
Did you click "show updates" in ARP? If you install Hotfix KB953595, it should show up in your ARP.
Thanks for the response Ray. Yes it does show up, but with the Uninstall button disabled. The uninstall button is enabled for all of the other Updates. So, I went looking for the installation package in \Windows\SoftwareDistribution\Downloads, but there is no package for this Hotfix, which I'm sure is why the Uninstall button is disabled, so I can't figure out how to force it's uninstall.
-ScottOK, here's the resolution I came up with. I gave up on uninstalling the Hotfix, and just uninstalled the .NET Framework 3.5 SP1 which also removed the Hotfix. I then re-installed the .NET Framework 3.5 SP1 without the Hotfix and went on to successfully finish the SQL Server 2008 installation.
That's so great to hear that.
Hey, I've been suffering the same issue. I uninstalled .NET 3.5 SP1 and it did remove the hotfix, however when I reinstall SP1 it also automatically reinstalls the hotfix which doesn't get me anywhere. SQL 2008 fails to install unless you have SP1 installed, so this appears to be a no win situation. How did you install SP1 without the hotfix?
Thanks, Ed
I have been struggling with this today, too. I have a new machine with Vista Home Premium. I get through all prereqs for SQL Server 2008 except the Restart Computer has failed on it and I can't install SQL Server 2008. However. I have restarted and still get it.
I have uninstalled .NET 3.5 SP1, reinstalled it, installed Visual Studio 2008, but still get the Restart computer failed. I don't see how to uninstall the Hotfix as there is no option in add/remove programs.
I was able to get around this problem by running the .exe for the installer which unpacked everything into a GUID-named folder on c:\ (which is a pretty bad idea for them to do, imho, instead of %temp% or something). I had to do this because letting the installer complete normally it would delete the folder. Once the installer window came up, I forcefully terminated the installer which left the folder intact. Then I opened a command line and ran setup manually (which is in the root of this folder), using the additional arguments mentioned earlier in the thread for skipping the forcereboot check. I don't recall the exact parameters but I had to add something like "Action=Install" to the command line before it would work. Once the installer GUI came up, it allowed me to install despite it saying that it still needed a reboot.
By the way, this was a really unpleasant experience that wasted several hours for me - and apparently at least a few other people - for something that *really* should have just been a warning for the installer especially since there is no indication of what, specifically, is triggering the installer to believe a reboot is required.
Also, if the package EXE had an option to just "unpack & install manually" that would have also been helpful because it was a bit of a chore just figuring out where the setup.exe was actually coming from.
Regards,
- can you please tell us what parameters you used that allowed you to forcefully bypass the computer reboot check.
I've tried all other ways but nothing seems to work.
Clearing the value in the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\PendingFileRenameOperations and without restart the computer, I was able to install SQL Server 2008. This issue really bugged me.- Proposed As Answer byIvan Sanders Friday, December 26, 2008 8:02 PM
Sorry for the delay, Ed. It must be something in the way you are doing the re-install. I had downloaded and saved locally the .NET 3.5 SP1 package first before re-installing it, and was not forced to also install the hotfix. Hopefully by now you've resolved the issue. Sorry I can't be of more help.
-Scott
This worked for me. Was an HP server and some piece of HP software was listed here. Once I deleted it the install went through.- This trick worked for me too.
What is the parameter to skip the forceboot check in the command line install.
- Updating the registry helped me. Thanks
- Removing the PendingFileRenameOperations value, as mentioned here worked for me.
I've been bugged with this for days, and now finaly could proceed the installation.I'm running Windows Server 2008 Standard Edition x64, with VS2008 and all/most updates (SP1 ++)...Thanks! I just cleared the Pending File Operations key and it worked.
Thanks to Everybody.
Searching for the string PendingFileRenameOperations and removing everything
containing this helped me to solve the problem and uninstall this SQL server. Which I never use and don't know what it is. I just wanted a simple C comiler (for noobs) and installed bloated MS Visual express something. It unistalled ok, but left me with this junk.
\??\D:\TEMP\logishrd\LVPrcInj01.dll
\??\D:\TEMP\logishrd\
\??\D:\TEMP\logishrd\LVPrcInj02.dll
\??\D:\TEMP\logishrd\
Above was mentioned in PendingFileRenameOperations in my system. ____ logitech software, or ____ windows update system...
didn't even have to restart sql server setup, could just re-run the tests! Thanks all that replied.
Thank you Amy, Clearing the value in the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\PendingFileRenameOperations defionetly works. You may remember we had the same issue with SQL 2005 and I think with SQL2K ....
-Ivan
Ivan Sanders http://linkedin.com/in/iasanders http://dimension-si.com/blog- I am running Vista SP1 with Visual Studio 2008 SP1, and .NET 3.5 SP1 having the same problem many have had. I like many others do not have a KEY registry entry for:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\PendingFileRenameOperations
What many seem to think (as I did) that there is a KEY value of PendingFileRenameOperations. There is no KEY by that name. There is however a Value Pair named "PendingFileRenameOperations" under:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager
Navigate to the above registry location and then look in the right side pane for the value pair. Rename it or delete the value found there.
In my case I have a Logitech CAM device that incorrectly completes its install without deleting the value pair.
After correcting the registry my install completed as expected.- Proposed As Answer byJ Larry Aultman Wednesday, December 31, 2008 4:32 PM
- Larry is right. Thats how i found the registry entry. I deleted the gargabe in there and was able to get through that hurdle just to run into more problems. An hour later i finally was able to install the Tool Pack ( which is all i wanted ). This is the worst installer i have seen in a long time. It took 4 hours and a ton of frustration to finally get access to the Management studio.
- Larry's answer fixed it for me to, on Vista Business 32bit SP1. Just deleted the values and reran the test...
- Thank you for this solid information. I have worked on this for some time and this worked out very well, once I deleted the value identified above and reinstalled, it worked well.
Thanks for the help.
CHS - One other thing I found, but didn't see posted here was the following:
http://scottonwriting.net/sowblog/posts/13456.aspx
Basically, the Express Editions don't get updated with VS SP1, and will cause the SQL install to fail. Uninstalling the Express Editions, installing SQL, then reinstalling the express editions (now with SP1) worked for me. - The same issue arose when I tried to UNINSTALL SQL2008 - restart computer: failed.I cleared my PendingFileRenameOperation keys, and the uninstall worked (Vista business)(reason for uninstall - because Windows 7 RC won't install with SQL there!)
developer - i couldn't find the registry in an explorer window... so i used ccleaner and that works fine.
nvm. im such a noob. you guys should EXPLAIN how to get there. ...nobody... okay i will.
open a command prompt as administrator. type in regedit.exe
then go to the directory specified above.
your welcome my fellow noobs.- Edited bymungodude Sunday, June 07, 2009 10:36 PMclarification of previous posts
- Thanks Amy!! Your solution worked. I simply deleted the values in the PendingFileRenameOperation option, and I got the install to finally work! Only wasted 2 hours trying to resolve this issue :). Glad I found this thread.
Jason
http://www.stocknod.com- Proposed As Answer bymrcookies Wednesday, August 05, 2009 9:14 PM
- That was the magic. I hit my head against this for just a tools install for 2 hours. Thanks!
- Thanks, that helped me as well. Unfortunately I wasn't as lucky as the others, I spent days working on it. Freakin' ____
- I have the same problem on my XP and VISTA computer. Have you solved this problem? I'd like to know how to do it too.Thanks.
- Clearing the value here worked for me on Vista
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\PendingFileRenameOperations - Here is what I did on my client machine. ( I was able to install VB Studio '08 and SQL Srvr. '08 on Windows 2003 Ent/w no issues).
But, on my XP client machine, I got the same error that the a restart failed.
I went to my registry: HKEY_LOCAL_MACHINE\SYSTEM\CONTROL\SESSION MANAGER\
Looked for the filerename issue. Checked to ensure it was not a file that can cause me problems later on, and deleted this key. Again!
Make sure it is not a file that can cause you problems. How do you know it won't cause you problems once you delete the failed registry key?
Ensur you know which file it is that the install was trying to rename and if need be rename it yourself by: right clicking on the key itself and select "Modify". I delete it mine and rerun the install, everything works well and I see no errors in my Application log; system or WPS.
All the best! Good luck!
I am installing SQL Server 2008 AND SQL Server 2008 R2 on a Windows 2008 server, and I am getting the above issue even after rebooting. This issue is happening with both SQL Server 2008 and SQL Server 2008 R2. The registry fix doesnt apply because that key doesnt exist at all (There is no CONTROL node in my registry) . I had to install Visual Studio 2008 + SP1 first because the install will fail because I am missing VS 2008 SP1.
All of the above work arounds do not work.
- Registry Node doesnt even exist,
- This is frist time i have EVER had this problem installing SQL 2008
- Have Rebooted 5 times
Any other ideas?
Rex Whitten- Rex,
Please check my post above (Dec 31, 2008) and verify your registry path. It took me several times to realize that I was in the wrong place.
Depending on the tools you are requesting installed you may not need VS 2008. You will need .NET 3.5 sp1. VS 2008 sp1 install .NET 3.5 sp1.
If you could post your exact error message that would be helpful.
Larry
