INF: Installation Order, Cluster Server Support for SQL or MSMQ

ID: Q192708

The information in this article applies to:

SUMMARY

When setting up a new SQL Server for clustering, a specific order of installation is recommended. This article documents the optimal procedure for installing multiple Microsoft products, including Internet Information Server (IIS), Cluster Server, SQL Server, Microsoft Distributed Transaction Coordinator (MS DTC), and/or Microsoft Message Queue Server (MSMQ), for use in a cluster environment.


MORE INFORMATION

Failure to install the programs in the order provided in this article may cause the software products to fail on installation, and/or require that the disk be reformatted and installation restarted.

  1. Install Windows NT Server 4.0 Enterprise Edition on each node, along with all necessary Windows NT services, protocols, and network adapters.


  2. Install Windows NT 4.0 Service Pack 3 on each node. Verify that both nodes can access the shared drive resource.


  3. Please install Internet Explorer 4.x/5.x now. A copy may be obtained from http://www.microsoft.com/ie or from the Windows NT Service Pack 4 compact disk that can be ordered from http://www.microsoft.com/ntserver/nts/downloads/recommended/nt4svcpk4/ordercd.asp.


  4. Install Microsoft Clustering on each node.

    NOTE: If you are using the Active/Passive model, set both computers to use the same drive letter for the shared resource; if you are using the Active/Active model, the drive letters should be sequential.


  5. Verify that both computers can access the cluster resource or resources.


  6. If MSMQ is required, you should install it now. If it is not required, proceed to step 8 below. If you need an MSMQ Primary Site Controller (PSC) installed on the cluster, you need to delete the site from the Primary Enterprise Controller (PEC) after installing on Node1, but before installing on Node2. Otherwise, use the MSMQ cluster install instructions provided in the release notes.

    For additional information, please see the following article in the Microsoft Knowledge Base:
    Q188685 HOWTO: Install an MSMQ PSC on Microsoft Cluster Server


    NOTE: The version of SQL Server installed by MSMQ has a default sort order of Code Page 51, which provides the reverse case sensitivity of a standard SQL Server installation.


  7. To avoid possible conflicts with files in use during installation, you should only have the following services running:



    Possible conflicting services include:

    If any of these services are started, they must be stopped before installing SQL Server.


  8. 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 being used. You can only do installations of SQL server to both nodes if each node has its own shared resource.

    WARNING: All SQL Server functionality including SQL Server Performance Monitor counters must be verified prior to clustering SQL Server.

    NOTE: If MSMQ is installed and the limited SQL Server required by MSMQ servers is installed, you should upgrade it according to the procedure described in the following article in the Microsoft Knowledge Base:
    Q183672 HOWTO: Upgrade a Clustered MSMQ SQL to SQL Enterprise Edition


  9. Install SQL Service Pack 5a. SQL Service Pack 5a is available for download at:

    ftp://ftp.microsoft.com/bussys/sql/public/fixes/usa/SQL65/Sp5/

    Service Pack 5a will attempt to install a clustered version of DTC, it is recommended that you do not install DTC as part of the service pack installation but instead install it after SQL has been re-clustered. This means that you WILL NOT need to create resources for DTC specifically as stated in the readme file. This DTC group needs to be owned by the first node you install Service Pack 5a on. When you later apply Service Pack 5a on other nodes of the cluster, make sure the DTC group remains owned by the first node. By failing to create the resources as described in the readme file, this will produce a resource not found error when DTCsetup is run during the service pack installation, choose to Cancel say OK. To the error message and allow the Service pack installation to continue.


  10. Install the Windows NT 4.0 Option Pack, choosing the options required.

    NOTE: If DTC is installed, the DTC log must be installed to the shared resource. When setting this up, after clustering is installed, do not click OK to restart Node1 until AFTER you have installed Windows NT 4.0 Option Pack to Node2. At the end of the installation on Node2, click OK and allow it to restart. Then and only then, click OK to restart Node1.


  11. Immediately install Windows NT 4.0 Service Pack 4 on each node. For more information about installing Windows NT Service Pack 4 on a cluster, see the Readme.txt file included with Windows NT 4.0 Service Pack 4. Also see the following article in the Microsoft Knowledge Base:
    Q174799 How to Install Service Packs in a Cluster


  12. Install any additional server products before installing any user applications.


Additional query words: prodsql MSCS EE Cluster Install NTSRV IIS4 sp sp3 


Keywords          : SSrvInst 
Version           : winnt:1.0,2.0,4.0,6.5
Platform          : winnt 
Issue type        : kbinfo

Last Reviewed: June 17, 1999