In my last post, we talked about How to Troubleshoot and Fix Webservice Timeout Issues.Today, we will talk about another issue “unable to install SQL Server”.
Solution 1: Install the patch
Try applying the SP3/SP4 patches for the operating system. If already applied, try again.
First, uninstall SQL Server, then delete the “Microsoft SQL Server” folder created during installation. Open the registry and delete the HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server and HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server keys (ensure the entire Microsoft SQL Server folder is deleted). Restart, and then reinstall; it should work fine!
Problems installing SQL Server 2000 on Win2k are common:
● Interruptions during server configuration.
● Interruptions while registering ActiveX.
● Interruptions when reaching 100% completion.
Reinstalling Windows 2000 usually resolves these issues.
For safety:
1. Backup your registry.
2. Backup your data [If unable to access SQL Server 2000, backup the files in Program Files/Microsoft SQL Server/MSSQL/Data folder.]
Important: Windows 2000 Server can install any version of SQL Server 2000. Windows 2000 Professional can only install the personal edition of SQL Server 2000.
There are two methods for that:
1. Uninstall SQL Server 2000 and delete the Program Files\Microsoft SQL Server folder if necessary.
Insert the SQL Server 2000 disk.
Run “F
.exe k=dbg” (where F is the disk) from “Start” -> “Run” [This command runs the SQL Server 2000 installation step by step.]
2. If installation fails at 98% without any prompt, it could be due to:
Interruptions during server configuration.
Interruptions while registering ActiveX.
Interruptions when reaching 100% completion.
In this case, use the following method or format the drive:
Open the registry. Run “regedit” from “Start” -> “Run.”
Follow the path:
HKEY_LOCAL_MACHINE
SOFTWARE
Microsoft
Windows
CurrentVersion
Setup
ExceptionComponents
Delete all folders under ExceptionComponents.
Restart.
Reinstall SQL Server 2000.
Solution 2: Modify the options
Search the registry and delete all mssqlserver options. Delete the SQL installation directory.
Copy the SQL installation files to the hard drive to ensure all files are properly read (to rule out file issues).
Restart the operating system, then reinstall.
If the problem persists, try repairing the operating system first.
Run the command:
sfc /scannow
Then reinstall using the steps above.
As a last resort, try installing Microsoft Data Access Components (MDAC) 2.8
If that doesn’t work, insert the operating system installation disk, choose the repair option during installation.
After completion, retry the installation using the first method.
If it still doesn’t work, reinstall the operating system.
To avoid restarting the computer: Delete the registry key: HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Control\Session Manager\PendingFileRenameOperations.
