"Server configuration failed" error prompted during MSSQLSERVER Installation

This article shares a general solution to the error "server configuration failed" reported by MSSQLSERVER2000 installation. If you need it, refer to it.

This article shares a general solution to the "configuration SERVER failed" error reported by mssql server 2000. If you need it, refer to it.

1. If you do not want to reinstall the system after MSSQL installation fails, copy the installation file to another machine of the same system version (or find a machine with MSSQL installed ), install it in the default path. After installation, copy the C: Program FilesMicrosoft SQL Server Directory to the faulty machine and replace the original file. This step also verifies whether the installation package is complete, otherwise it cannot be installed on other machines.

2. Run the installer again on the faulty machine, select "advanced options", and then select "Registry reconstruction". Then, the installer will be installed normally. If any file is missing in the middle, copy it from a good machine and put it in the same directory.

3. After completing step 3, run the MSSQL installer again. This time, select the 2nd option "upgrade, delete, or add components to an existing SQL SERVER instance ", at this time, you will see that all components are not checked, select the required components (usually the first three items on the left), and then "Next" is like normal installation.

4. After step 4 is completed, the Microsoft SQL Server project appears in the Start Menu. The SQL service should also be able to start. However, the SP4 patch has not been installed yet. After SP4 patch is installed, "Verification Failed" may be reported during patching. click Retry and log on to the sa account (the password may be blank) to continue the installation.

5. You can use the patch after it is installed. However, the Enterprise Manager may not be able to connect to the SQL service. Right-click to edit the registration and use the sa account (the password may be blank) to connect, after the connection, you can add the administrator account in "login" to log on to the windows account. Do not forget to change the sa password.

If the above solution still cannot be solved, I guess the system may have serious problems. We 'd better reinstall the system.

Other methods for Baidu online

Frequently Asked Questions When installing SQL Server 2000

(1) server configuration is interrupted.

(2) ActiveX registration is interrupted.

(3) interrupted when 100% is displayed.

(4) Prompt: command line option syntax error, type command /? For help, continue the installation, and finally appear When configuring the server: The Dynamic Link SQLUNIRL. DLL cannot be found in the specified path ......

(5) previously, the program created a pending file. Before running the installer, you must restart it.

(1) (2) (3) solution:
Reminder: To avoid misoperation, You can first back up the registry and cannot access SQL Server 2000. You can back up files in the Program FilesMicrosoft SQL ServerMSSQLData folder.
1. Uninstall SQL Server first (it does not matter if it cannot be detached. Continue the following operations)
2. Delete the entire Microsoft SQL Server folder.
3. Run the registry and delete the following items:
HKEY_CURRENT_USERSoftwareMicrosoftMicrosoft SQL Server
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServer
4. restart the system
5. reinstall

You can also try to Install SQL Server 2000 in one step:

1: Put the SQL Server 2000 CD.
2: At "start" -- "run", type "F: x86setup.exe k = dbg" (F is a CD)

Note:
1. SQL Server 2000 supported by different operating systems and hardware requirements.
Windows 2000 Server can install any version of SQL Server 2000.
Windows 2000 Professional can only install the Personal Edition, development edition, evaluation edition, and MCDE of SQL Server 2000
II,
SQL Server 2000 versions and hardware requirements.
(4) Solution

Because the installation file path (full path) contains Chinese characters.
For example, c: SQLSERVER Chinese Enterprise Edition
Change to c: SQLSERVER

(5) Solution
A. Restart the machine and install it again. If the error persists, follow these steps:
B. Enter regedit in start-> running
C. To the HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlSession Manager location
D. Select File-> inverted, save
E. Right-click PendingFileRenameOperations in the right window, select Delete, and then confirm
F. Restart the installation and solve the problem.
-------------------------------------------------------
If the problem persists, try to fix the operating system first.

Run the following command prompt:
Sfc/scannow

Last method: Change the Windows 2000 installation disk and SQL Server2000 installation disk.
Sometimes the cause of the problem is very strange. Someone once changed a power supply to solve the problem.

1. Uninstall your SQL Server 2000 and delete the Program FilesMicrosoft SQL Server folder if necessary.
2 open the Registry
In "start" -- "run", type "regedit"
3. Click to open in the following order
+ HKEY_LOCAL_MACHINE
+ Softlinks
+ Microsoft
+ Windows
+ CurrentVersion
+ Setup
+ Predictioncomponents
4. 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}
6 restart:
7. Re-Install SQL Server 2000