MS SQL Server 2000 Enterprise Edition installation error

My laptop has VS 2005 installed. I am trying to install MS SQL Server 2000 Enterprise Edition, when i run "install database components", it gave error: "MS SQL Server 2000 Enterprise Edition component is not supported on this operating system. Only client components will be available for installation". then when i click on "ok", then "next", when i click on "next" on the "computer name" page, it gave another error: "A previous program installation created pending file operations on the installation moachine. You must restart the computer before running setup". I restarted my laptop following the instruction, but same thing happened when i run the installation. Plz help

Enterprise edition will only install on Server Operating systems, so it won't install on XP.

Any application can set a pending reboot flag in the operating system through a registry key. Sometimes a reboot does not clear the flag. This is what setup is detecting.

To work around the pending reboot issue:
1/ Open Regedit
2/ Find the key "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager"
3/ Rename the "PendingFileRenameOperations" value to "PendingFileRenameOperations2"

|||

thx Jeffery for the quick reply, I was able to install the client components by following your instruction. thx for your help and good luck for 2006 :)

|||Really this was helped very much after changing the registry smoothly sql 2000 installed and working smoothly , thanks ton.|||I've checked that registry location and can't find the listed key in the path listed. Yet, the error persists. I'd love to solve this. If I do I'll edit this post if I can with the results.|||

hi Bob, when u go to "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager", just click on the "Session Manager" folder on the left hand side treeview, then u will find "PendingFileRenameOperations"

|||

I understand what I'm looking for but it's not there at all. There is no 'PendingFileRenameOperations' folder under Session Manager.

I've even did a 'find' for 'PendingFileRenameOperations'. It returned an entry under HKLM\System\ControlSet001\Control\BackupRestore\KeysNotToRestore.

I checked another XP Pro machine I have an it doesn't have the key either.

Got any other clues?

Thanks for your help

|||'PendingFileRenameOperations' is not a folder, it's just a value name. when u left-click on the Session Manager folder on the left, there will be a list shown on the right, u can find the 'PendingFileRenameOperations' in the list.|||

I can't find it as a value in SessionManager or as a folder or anywhere other than in the location indicated above. It's just not there.

I can't seem to find it anywhere. So, I guess what I'm saying is that since it is not 'required' (which it seems to the case since renaming it allows the SQL server to install) and I don't have one, why is it still that I can't install?

|||

Well, that is only for the error "A previous program installation created pending file operations on the installation moachine. You must restart the computer before running setup".

Is that what you are seeing? If not, could you start a *different* thread describing the error that you are seeing?

|||I'm sorry. I checked the KB and these two errors seemed to be lumpped together. I'll start another thread.|||This was a fantastic help! I had this same problem and tried all sorts to solve.
This worked a treat! Cheers :)|||

Thank you, Thank you. This solved my problem. I'm so glad I found you and this posting on Microsoft TechNet. I wasn't even sure how to describe this problem, but am so thankful for your help.

Now, I can finish installing SQL Server and the upgrade Service Packs. Thanks again.

Gary

|||gracias...|||I have tried to change the name of the file in the regedit and I am still receiving the same error that a previous program installtion created pending file operations on the installation machine. You must restart computer before running setup. What do I do now? i ahve restarted 3 times.