DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 192710 - Last Review: October 26, 2007 - Revision: 5.4

This article was previously published under Q192710

On This Page

SUMMARY

This article describes the general requirements and steps for installing the SQL Server 6.5 or SQL Server 7.0 Standard or Enterprise versions on either Windows NT 4.0 or Windows 2000.

WARNING: Failure to install the programs in the order listed in this article may cause the software products to fail on installation, or require that you reformat the disk and restart the installation.

NOTE: For details on which versions of SQL are supported on each operating system, see the following article in the Microsoft Knowledge Base:
122352  (http://support.microsoft.com/kb/122352/EN-US/ ) INF: Supported Windows Versions for SQL Server

CAUTION: If you are installing Microsoft SQL Server version 7.0 along side SQL Server 6.x on the same computer, do not install SQL Server 7.0 in the same directory as SQL Server 6.x.

MORE INFORMATION

Order of Installation using Windows NT 4.0 Server or Enterprise Edition, Non-clustered

Install the services in the following order:

  1. Install Windows NT along with all the necessary Windows NT services, protocols, and network adapters.

    Tip: If your computer is not connected and logged on to a network and you are using Windows NT 3.51 or 4.0, you need to install the Microsoft Loopback Adapter. Your Windows NT installation compact disc and the latest Windows NT Service Pack (if installed) is required. To install the Microsoft Loopback Adapter under Windows NT 4.0, perform the following steps:

    1. Right-click the Network Neighborhood icon and click Properties, or double-click Network in Control Panel.
    2. In the Network Properties dialog box, click the Adapters tab, and then click Add.
    3. Select MS Loopback Adapter from the list, and then click OK.
    4. Accept the defaults.
    To install the Microsoft Loopback Adapter under Windows NT 3.x, follow these steps:
    1. In Control Panel, double-click the Network icon.
    2. Click Add Adapter.
    3. Select MS Loopback Adapter and then click Continue.
    4. Accept the defaults.
  2. If you are using the IPX/SPX protocol, accept the default frame type of 802.3. For TCP/IP configurations, you should specify an IP address of 10.10.10.1 and a subnet address of 255.255.255.0. When you are prompted to restart the computer, click No.
  3. Clear the event logs, restart the computer, and log in using an Administrator account. If the computer is on a network and is a member server, verify that this account is a member of the local Administrators group.
  4. Verify that the Windows NT event logs are empty except for normal service startups.
CAUTION: ALL OTHER ERRORS OR MESSAGES CONCERNING FAILURES OR OTHER PROBLEMS SHOULD BE RESOLVED BEFORE CONTINUING.

Internet Explorer

If needed, or if you plan to use it in the future, install Internet Explorer 4.0 or later. If you do not already have a copy, you can obtain the latest version by going to the following Web site:
http://www.microsoft.com/windows/ie (http://www.microsoft.com/windows/ie)

Conflicting Services

  1. Switch all services to Manual mode; however, do not touch the following services (if present):

    • Alerter
    • Cluster Service
    • Computer Browser
    • Distributed File System
    • Distributed Link Tracking Client
    • Distributed Link Tracking Server
    • DNS Client
    • Event Log
    • IPSEC Policy Agent
    • License Logging Service
    • Logical Disk Manager
    • Messenger
    • Net Logon
    • NTLM Security Support Provider
    • Network Connectors
    • Plug and Play
    • Process Control
    • Remote Procedure Call (RPC) Locator
    • Remote Procedure Call (RPC) Service
    • Remote Registry Service
    • Removable Storage
    • Security Accounts Manager
    • Server
    • Spooler
    • TCP/IP NetBIOS Helper
    • Time Service
    • Windows Management Instrumentation Driver Extensions
    • Windows Time Service
    • Workstation
    NOTE: Some installations may not have all of these services, because this list covers both Windows NT 4.0 Enterprise Edition and Windows 2000 Advanced Server.
  2. Close Control Panel and reboot the server. This clears memory of DLLs loaded by services; otherwise, these services would remain in memory and hold locks on system resources.

SQL Server 6.5

To begin installing SQL Server 6.5, run Setup.exe from the correct directory on the SQL Server 6.5 compact disc. If you are using BackOffice, start the Install Wizard. During the installation, choose the default settings, unless you have a specific reason for changing them. When you install SQL Server onto a computer running Windows NT Workstation, choose for the services to start under the Local System Account instead of assigning a user account.

Windows NT 4.0 Option Pack with SQL Server 6.5

Install the Windows NT 4.0 Option Pack, choosing the options required. If you have a compact disc for Option Pack 4.0 or you downloaded the Windows NT 4.0 Option Pack from the Web site, make sure that you have the correct version for Windows NT Workstation or Server.

SQL Server 6.5 Service Pack 5a

Install SQL Server 6.5 Service Pack 5a, which is available from the following Web site:
http://www.microsoft.com/downloads/results.aspx?pocId=&freetext=SQL%20Server%206.5%20Post%20Service%20Pack%205a%20Update&DisplayLang=en (http://www.microsoft.com/downloads/results.aspx?pocId=&freetext=SQL%20Server%206.5%20Post%20Service%20Pack%205a%20Update&DisplayLang=en)

SQL Server 7.0

If you are planning to use the Windows NT 4.0 Option Pack this must be installed prior to installing SQL Server 7.0.

Windows NT 4.0 Option Pack with SQL Server 7.0

Install the Windows NT 4.0 Option Pack, if required, by choosing the options required. If you have a compact disc for Option Pack 4.0 or have downloaded it from the Web site, make sure that you have the correct version for Windows NT Workstation or Server.

Prior to the actual installation you must have installed the Windows NT 4.0 Service Pack 4.

When you insert the Windows NT Service Pack CD it is recommended that you from the right side of the screen, select Service Pack 4 installation and select either the Intel-based or Alpha-based system. By making the choice from the right side you execute the Y2ksetup.exe file, which not only installs the Windows NT Service Pack but provides the correct installation order for upgrading program versions to resolve known Year 2000 issues.

If you are installing the Windows NT Service Pack from a downloaded version, install the Windows NT Service Pack you instructed at the time of the download.

SQL Server 7.0

To start the actual SQL Server 7.0 installation:

  1. Insert the SQL Server compact disc into your CD-ROM. If the compact disc does not autorun, double-click the Autorun.exe file in the root directory of the compact disc.
  2. Click Install SQL Server 7.0 Components.
  3. Click either Database Server - Full Product or Database Server - Desktop Edition.
  4. Select the type of installation to perform, and then click Next:

    • Typical
    • Minimum
    • Custom
    If you chose a custom installation:


    • Select the components to install.
    • Select a character set, sort order, and Unicode collation.
    • Select the network libraries to configure.
  5. If you are installing on a server running Windows NT, enter a username and password for the SQL Server service or select Use the local system account.

    The SQL Server Agent service defaults to the same account entered for the SQL Server service unless you specify another account.
When you have finished specifying installation options, the Setup program installs SQL Server.

Windows NT Service Pack 4

Install the latest Windows NT 4.0 Service Pack. Users of the Windows NT 4.0 Enterprise Edition must install Service Pack 3 to complete the initial install process.

When installing the service pack, make sure that you select to create an uninstall directory and use the Year 2000 setup from the CD-ROM. This is done by selecting to install from the choice in the frame on the right side of the screen that appears when the compact disk auto runs.

NOTE: Prior to installing Windows NT Service Packs, it is recommended that you verify that your current Windows NT Service Pack uninstall directory has been renamed. It is also recommended that you rename the hidden directory, $NTServicePackUninstall$, to $NTServicePackUninstall$.SP4 and then rename it again after installing any future Service Packs, by adding .SPx as the extension, where x is the Service Pack number. This way you have uninstall directories available, should you need them. This also prevents the directories from being accidentally overwritten.

Additional Server-Based Applications

Install any additional server-based products before installing any user applications. For further information, please see the following article in the Microsoft Knowledge Base:
166237  (http://support.microsoft.com/kb/166237/EN-US/ ) HOWTO: Setting Up Visual Studio onto Multiple Smaller Drives

Order of Installation using Windows 2000 Overview

Install Windows 2000 Server or Advanced Server

  1. Install Windows 2000 Server or Advanced Server and accept the default application choices.
  2. Unless you are planning on using a local system account, create a service account for SQL. If you already have one verify it's policies so that it has:

    1. Right to act as part of the operating system.
    2. Logon as a service.
    3. Logon locally.
    4. This account must be part of the Local Administrators Group
    NOTE: This requires a Domain Administrators account to set up the domain policy. For assistance, refer to "Windows 2000 Group Policy Scenarios" at:
    http://technet.microsoft.com/library/Bb742376.aspx (http://technet.microsoft.com/library/Bb742376.aspx)
  3. Stop all services except:
    • Alerter
    • Computer Browser
    • Distributed File System
    • Distributed Link Tracking Client
    • Distributed Link Tracking Server
    • DNS Client
    • Event Log
    • IPSEC Policy Agent
    • License Logging Service
    • Logical Disk Manager
    • Messenger
    • Net Logon
    • NT LM Security Support Provider
    • Network Connectors
    • Plug and Play
    • Process Control
    • Remote Procedure Call (RPC) Locator
    • Remote Procedure Call (RPC) Service
    • Remote Registry Service
    • Removable Storage
    • Security Accounts Manager
    • Server
    • Spooler
    • TCP/IP NetBIOS Helper
    • Windows Management Instrumentation Driver Extensions
    • Windows Time Service
    • Workstation
    NOTE: If you have followed the steps above and your installation is failing, check the setup.log in your %systemroot% directory for a log entry showing:
    Connecting to Server ...
    driver={sql server};server=.;UID=sa;PWD=;database=master
    [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.
    driver={sql server};server=.;UID=sa;PWD=;database=master
    [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.
    driver={sql server};serverVATLAS01;UID=sa;PWD=;database=master
    [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.
    SQL Server configuration failed.
    If this is present, you may need to install the Windows 2000 High-Encryption Pack prior to installing SQL 7.0.

Installing SQL Server 6.5

  1. Install SQL Server 6.5 Enterprise Edition on the cluster, as directed in the WhatsNew document located in the I386 directory of the SQL Server 6.5 Enterprise Edition compact disk. Pay special attention to the portion of this process that is different depending on the cluster model you are using. You can only perform installations of SQL server to both nodes if each node has its own shared resource.
    WARNING: When an error occurs installing the Microsoft Distributed Transaction Coordinator (MSDTC) you should select Cancel. MSDTC is installed by default with Microsoft Windows 2000.
  2. Install the SQL Service Pack 5a. SQL Service Pack 5a is available for download at:
    ftp://ftp.microsoft.com/bussys/sql/public/fixes/usa/SQL65/Sp5/ (ftp://ftp.microsoft.com/bussys/sql/public/fixes/usa/SQL65/Sp5/)
  3. Install any additional server products before installing any user applications.

Installing SQL Server 7.0

To start the actual SQL Server 7.0 installation:

  1. Insert the SQL Server compact disc into your CD-ROM. If the compact disc does not autorun, double-click the Autorun.exe file in the root directory of the compact disc.
  2. Click Install SQL Server 7.0 Components.
  3. Click either Database Server - Full Product or Database Server - Desktop Edition.
  4. Select the type of installation to perform, and then click Next:

    • Typical
    • Minimum
    • Custom
    If you chose a custom installation:
    • Select the components to install.
    • Select a character set, sort order, and Unicode collation.
    • Select the network libraries to configure.
  5. If you are installing on a server running Windows NT, enter a username and password for the SQL Server service or select Use the local system account. The SQL Server Agent service defaults to the same account entered for the SQL Server service unless you specify another account.
When you are finished specifying installation options, the Setup program installs SQL Server.

APPLIES TO
  • Microsoft Internet Explorer 4.0 128-Bit Edition
  • Microsoft Windows NT 4.0
  • the operating system: Microsoft Windows 2000
  • Microsoft SQL Server 6.5 Standard Edition
  • Microsoft SQL Server 6.5 Service Pack 1
  • Microsoft SQL Server 6.5 Service Pack 2
  • Microsoft SQL Server 6.5 Service Pack 3
  • Microsoft SQL Server 6.5 Service Pack 4
  • Microsoft SQL Server 6.5 Service Pack 5a
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 6.5 Enterprise Edition
  • Microsoft SQL Server 7.0 Enterprise Edition
Keywords: 
kbproductlink kbinfo KB192710
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support