Troubleshooting SQL Server 2000 installation issues
March 12, 2003
Should you have problems installing SQL Server 2000, review this troubleshooting checklist to find potential solutions.
1. Check the hardware requirements.
You should have:
2. Check the software requirements.
You should have:
3. Check that your hardware is listed in the hardware compatibility list.
For more information about the specific supported hardware, look at the hardware compatibility list at http://www.microsoft.com/hwdq/hcl/search.asp
4. Login as a Local Administrator on the Server.
SQL Server needs the administrator's permissions to create registry entries, create services and so on.
5. Use the LocalSystem account for MSSQLServer and SQLServerAgent services.
You can change it later to an appropriate domain account, once you have successfully installed SQL Server. Using the LocalSystem account helps to reduce potential SQL Server installation problems.
6. Close the Service Manager icon in the taskbar.
Microsoft recommends closing the Service Manager icon in the taskbar because it may cause SQL Server Setup to fail.
7. Stop some services, which can cause installation failure.
Because some services may cause installation failure of SQL Server due to a Windows NT/2000 logon failure or time out, you should stop these services before installing SQL Server 2000, and then restart them once SQL Server has been successfully installed. Stop the following services:
8. Close all extraneous programs that are running.
Because extraneous programs use some system resources, it is a good idea to close all extraneous programs before installing SQL Server 2000. Be sure that there are no any programs on the taskbar except the Setup application.
9. Problems installing MS DTC on computers with multiple network cards or SPX installed.
If you cannot install MS DTC on a server with multiple network cards or SPX installed, uninstall one of the network cards or SPX, and then retry the SQL Server Setup.
10. You can get the error during installation of SQL Server 2000 Personal Edition or SQL Server 2000 Desktop Engine if there is a previous edition of SQL Server 7.0 Desktop Edition or MSDE 1.0 installed.
The cause of this error is that there is not enough system memory to run all of the necessary SQL scripts. You should have at least 48 Mb of RAM (for Windows 9x) rather than the 32 MB of RAM as stated in SQL Server Books Online.
11. Before reinstalling SQL Server 2000 after a failed install, delete the following registry entries:
and delete the target installation directory.
12. If you install SQL Server 2000 on Windows 9x, you should install Microsoft Client for Networks.
To install Microsoft Client for Networks, click Start -> Control Panel -> Network -> Add Microsoft Client for Networks.
13. To locate any problems during setup, check the sqlstp.log, setup.log and errorlog files.
The following files, found on your server, can provide valuable error messages if your SQL Server installation fails: