Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Mar 12, 2003

Troubleshooting SQL Server 2000 installation issues

By Alexander Chigrik

Should you have problems installing SQL Server 2000, review this troubleshooting checklist to find potential solutions.

1. Check the hardware requirements.

You should have:

  • Intel or compatible platform
  • Pentium 166 MHz or higher (Pentium II, III, IV and compatible)
  • 32MB RAM (minimum for Desktop Engine),   64MB RAM (minimum for all other editions)   128 MB RAM or more recommended
  • 270MB (full installation), 250MB (typical), 95MB (minimum),   44 MB (Desktop Engine) plus Analysis Services: 50 MB minimum   and 130 MB typical and 80 MB for the English Query

2. Check the software requirements.

You should have:

  • For the Enterprise Edition and Standard Edition:
    • Windows NT Server 4.0 with service pack 5 or later
    • Windows NT Server 4.0 Enterprise Edition with service pack 5 or later
    • Windows 2000 Server/Advanced Server/Datacenter
  • For the Personal Edition and Desktop Engine:
    • Windows 98
    • Windows NT Server/Workstation 4.0 with Service Pack 5
    • Windows NT Server 4.0 Enterprise Edition with Service Pack 5
    • Windows 2000 (all editions)
  • For the Developer Edition:
    • Windows NT Server/Workstation 4.0 with Service Pack 5
    • Windows NT Server 4.0 Enterprise Edition with Service Pack 5
    • Windows 2000 (all editions)
  • For the SQL Server CE:
    • Windows CE

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:

  • IIS - Internet Information Server
  • Exchange Server
  • SNA Server
  • Disk Keeper
  • SNMP Service
  • Anti-virus software (such as McAfee)
  • Backup products (such as ARC Server)

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:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLServerAgent
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

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:

  • sqlstp.log (located in your \Windows or \WinNT directory)
  • errorlog file (located in the \Log directory of the target installation directory)
  • setup.log file (located in your \Windows or \WinNT directory)

» See All Articles by Columnist Alexander Chigrik



MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM


















Thanks for your registration, follow us on our social networks to keep up-to-date