When SQL Server is installed, the system prompts "a file operation was suspended during previous installation of a program.

Source: Internet
Author: User
Tags mssqlserver
SQLServer2000 was installed yesterday. Because the local backup file did not respond after it was installed, it is estimated that the integrity of the SQL compressed package was damaged during virus removal. Therefore, the original MSSQL disc was installed, but the prompt was: previously, file operations were suspended during the installation of a program. Restart the program before installation. This problem should be caused by the previous installation

SQL Server 2000 was installed yesterday. Because the local backup file does not respond after it is installed, it is estimated that the integrity of the SQL compressed package is damaged during anti-virus; therefore, it is installed from the original MSSQL disc, however, the system prompts that file operations have been suspended during the previous installation of a program. Restart the program before installation. This problem should be caused by the previous installation

YesterdayInstallSQL Server 2000, due to local backupFileBefore tryingInstallAfter, no response, it is estimated that the SQL compressed package integrity is damaged during anti-virus; so from the original MSSQL DiscInstall,Prompt:PreviousAProgramInstallSuspendedFileOperation,InstallProgramPlease restart before. This problem should be caused by the previousInstallSomeFile, Registration key causes a newInstallFailed.

SolutionThe method is to clear the previousInstallSpam information left when SQL Server 2000 fails.

You do not need to restart the Registry. to modify the registry, choose "start"> "run"> "regedit"> open registry and find the following registry items:
Find the PendingFileRenameOperations project in HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Control \ Session Manager and delete it. In this way, the error can be cleared.Prompt"PreviousAProgramInstallSuspendedFileOperation,InstallProgramPlease restart before ".

If you try the aboveOperation, Or notInstallComplete the following steps:OperationRepeat:

1) Add/deleteProgramCompletely Delete SQL server.

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

3) Open the Registry Editor, find the PendingFileRenameOperations project in HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Control \ Session Manager, and delete it. In this way, you can clearInstallTemporarily suspended projects.

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

Step 1 is the most important! This is not found on the left.FileFolder, but from the right side! Tree on the leftFileThe folder 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:

HKEY_CURRENT_USER \ Software \ Microsoft SQL Server
HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft SQL Server
HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ MSSQLServer

All microsoft SQL SERVER and MSSQLSERVER are deleted!

Finally, we can go smoothly.InstallLater, I encountered the problem that the login was unsuccessful. The problem that the table could not be returned (when I want to create a new table, I will pop up "execute thisOperationAn unexpected error occurred during this period ") I found a lot of articles and tried to finally succeed! The process is really annoying ~~~~~~~ The procedure is as follows:

In the control panel-management tools-service, find one of MSSQLSERVER. Change the service account information of the MSSQLSERVER service to a user dedicated to the SQL service.

My practice is to select the logon identity "Local SYSTEM account ".

Set the logon option in MSSQL Enterprise Manager to "WINDOWS Verification" only"

OK.

Hope you canInstallOr not encountered so much trouble during the reinstallation process.

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.