When installing SQL statements, the system prompts that a pending file operation cannot be installed.

Source: Internet
Author: User
When installing the or sqlserver patch, the system always prompts that a previously installed program has created a pending file on the computer. The installation cannot be performed and the computer cannot be restarted,

When installing the patch for SQL server or SQL server, the system always prompts that a previously installed program has created a pending file on the computer. The installation cannot be performed and the computer cannot be restarted,

An error message is displayed: "A previous program has been installed to create a suspended file on the installation computer. You must restart the computer before running the program.

The solution is as follows:

Steps:

Start-run-enter regedit-open the registry,


1) Add/delete programs to completely delete SQL server.

2) Delete the SQL server Directory that has not been deleted.

3) Open the Registry Editor,

The Code is as follows:
Find PendingFileRenameOperations in HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlSession Manager.

Project, and delete it. In this way, you can clear the temporary installation project.

4) Delete the SQL server-related keys in the registry.

Step 1 is the most important !!! Here, we found not the folder on the left, but from the right !!! The tree folder on the Left does not have this project, and there is only one FileRenameOperations. It is useless to delete it.

Also, the SQL server-related keys in the registry include:

The Code is as follows:

HKEY_CURRENT_USERSoftwareMicrosoftMicrosoft SQL Server
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServer

All microsoft SQL SERVER and MSSQLSERVER are deleted!

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.