How to Troubleshoot SQL Server 7.0 Installation Issues

1. Check the Hardware Requirements You should have:

  • Alpha AXP, Intel or compatible platform
  • Pentium 166 MHz or higher (Pentium Pro, Pentium II and compatible)
  • 32MB RAM (minimum), 64MB RAM and more (recommended)
  • 180MB (full installation), 170MB (typical), 65MB (minimum)
  • 90MB (management tools only) plus 50MB for OLAP Services and 12MB for the English Query

2. Check the Software Requirements You should have: For the Desktop Edition:

  • Windows 95
  • Windows 95 OSR2
  • Windows 98
  • Windows NT Server/Workstation 4.0 with Service Pack 4
  • Windows NT Server Enterprise Edition
  • Windows 2000 (all editions)

For the Standard Edition:

  • Windows NT Server 4.0 with Service Pack 4
  • Windows NT Server Enterprise Edition
  • Windows 2000 Server/Advanced Server/Datacenter

For the Enterprise Edition: 

  • Windows NT Server Enterprise Edition
  • Windows 2000 Advanced Server/Datacenter

3. Check the Hardware Compatibility List For more information about the specific supported hardware, look at the hardware compatibility list at http://www.microsoft.com/hcl/default.asp

4. Login as a Local Administrator on the Server SQL Server needs these permissions to create registry entries, create services and so on.

5. Check that Network Card or Microsoft Loopback Adapter is Functioning SQL Server needs to use network functionality, so you should have network card, or a dummy driver Microsoft loopback adapter, which pretends to be a network card.

6. 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.

7. Before Reinstalling SQL Server 7.0 After a Failed Install, Delete the Following Registry Entries: HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServices
MSSQLServer
HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServices
SQLServerAgent
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServer
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server 7
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServ70 and delete the target installation directory (C:MSSQL7 by default).

8. If Upgrading from SQL Server Version 6.5

Ensure that the default database for the login ‘sa’ is master.

9. Stop These Services, Which Can Cause Installation Failure Try stopping these services before installing SQL Server 7.0, and then restart them once SQL Server has been successfully installed.

  • IIS – Internet Information Server
  • PWS – Personal Web Server
  • Exchange Server
  • SNA Server
  • Disk Keeper
  • SNMP Service

For more details see, see this URL: 
http://support.microsoft.com/support/SQL/Content/setup/setup1.asp

Continues…

Leave a comment

Your email address will not be published.