Solution to Mircosoft SQL Server Installation failure

1. SQL Server Installation Error: a previously installed program has created a suspended file on the computer. You must restart the computer before running the installer.

 

Install SQL Server 2000 Personal Edition for development, but each installation prompts "a previous program installation has created a pending file operation on the installation calculation meter. You must restart the computer before running the installer ." After the computer is restarted, the problem is not solved.

Solution:

1) Add/delete programs to permanently delete Microsoft SQL Server.

2) Delete the Microsoft SQL Server folder generated during installation.

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 clear the temporary installation project.

In this case, you can install Micrsoft SQL server without restarting the computer.

If the installation is still unavailable, follow these steps:

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

In fact, it is estimated that only step 1 can be done, so that you can clear the installation of temporary projects. I did this by leaving for 1, 2, 4, and 3. Therefore, estimation 3 is the most critical. It should be okay if you try again!

Ii. Common installation failures of Microsoft SQL Server 2000 in Windows 2000
// (1) server interruption during server configuration.
// (2) ActiveX registration is interrupted.
// (3) interrupted when 100% is displayed.
Of course, you can reinstall Windows 2000 to Install SQL Server 2000.

For security:
1> back up your registry first.
2> back up your data. If you cannot enter SQL Server 2000, you can back up files in the Program Files \ Microsoft SQL Server \ MSSQL \ data folder.

You must know:
Windows 2000 Server can install any version of SQL Server 2000.
Windows 2000 Professional can only install the personal and desktop editions of SQL Server 2000.

There are two methods:

1. Uninstall your SQL Server 2000 and delete the Program Files \ Microsoft SQL Server folder if necessary.
2. Add the SQL Server 2000 disc.
3. In "start" -- "run", type "X: \ x86 \ setup.exe K = dbg". [This command means to run and Install SQL Server 2000 in a single step]
4. The installation fails in 98%, and there is no prompt. It may be:
(1) server configuration is interrupted.
(2) ActiveX registration is interrupted.
(3) interrupted when 100% is displayed.

In this way, you can only use the following methods! Otherwise, you only have format!
1. Open the Registry
In "start" -- "run", type "Regedit"

2. Click to open in the following order
+ HKEY_LOCAL_MACHINE
+ Softlinks
+ Microsoft
+ Windows
+ CurrentVersion
+ Setup
+ Predictioncomponents
3. delete all the folders under predictioncomponents!
For example, {60bff50d-fb2c-4498-a577-c9548c390bb9}
{60bff50d-fb2c-4498-a577-c9548c390bb9}
{60bff50d-fb2c-4498-a577-c9548c390bb9}
{60bff50d-fb2c-4498-a577-c9548c390bb9}
.......

4. Restart the instance and reinstall SQL Server 2000.

 

Http://vir.jxstnu.edu.cn/xieyunc/read.php? 56