SQL Server 2000 installation fails with "...previous program installation..." error message

SYMPTOMS

When you install SQL Server 2000, this error message may occur:

A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup.

After the error message appears, the installation will not continue until you address the problem.

CAUSE

Pending file rename or delete operations.

WORKAROUND

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.


To work around this problem, depending on the source of the error, you can use any one of the following methods:

1. Restart the computer and see if you are able to run the setup. If the restart does not help, use the steps that follow.
2. Perform these steps and then run the SQL Server 2000 setup again:
   1. Click Start, and then click Run.
   2. In the Open dialog box, type: "Regedit" (without the quotation marks) or"Regedt32" (without the quotation marks)
   3. Click OK.
      
      NOTE: Please make sure that you only delete the value mentioned, not the whole session manager key.
   4. In Registry Editor, expand the following registry subkey:HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager
   5. On the File menu, click Export.
      
      NOTE: In Microsoft Windows 2000, click Export Registry File from theRegistry menu.
   6. In the File name text box, type: "Session Manager Key" (without the quotation marks)
   7. Click Save.
   8. In the right-pane of the Registry Editor window, right-clickPendingFileRenameOperations. On the shortcut menu that appears, click Delete.
   9. In the Confirm Value Delete message dialog box that appears, clickYes.
   10. On the File menu, click Exit.
       
       NOTE: In Windows 2000, click Exit on the Registry menu.
   11. Restart the computer.
   12. Using the Registry Editor, verify that thePendingFileRenameOperations registry value is not available.
       
       Note The PendingFileRenameOperations registry value may be re-created when you restart the computer. If the registry values are re-created, delete the PendingFileRenameOperations registry value again by completing steps a through j, and then run SQL Server 2000 Setup. Do not restart the computer before you run SQL Server 2000 Setup.
3. Check other control set keys (for example, ControlSet001, ControlSet002, and so forth) for the same values and also delete them.
4. Identify the virtual memory settings on the computer. If the paging file is too small or if there is no paging file, this error message may occur at startup:
   Limited Virtual Memory Your system has no paging file or the paging file is too small.
   If the error message occurs, determine the placement of the paging file from the virtual memory settings and give that drive full permissions for the system account.

REFERENCES

257758 FIX: "Limited Virtual Memory" Error Message When You Start Your Computer

259151 Paging File Functionality Requires System Account Permissions and Proper Size 

Courtesy:support.microsoft.com