How to Troubleshoot SQL Server 7.0 Installation Issues

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

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…

Pages: 1 2




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |