How to run Clustering Service setup on a new SQL Server 7.0 installation using the Failover Setup Wizard (Windows NT)

To run SQL Clustering Service setup on a new SQL Server 7.0 installation using the Failover Setup Wizard

  1. Identify the disk names controlled by the primary node of the cluster on which you will install Microsoft® SQL Server™.
  2. To stop any additional services such as IIS, MTS, MSDTC, and Exchange that may be running or installed by default on the cluster, right-click the resource; then click Take Offline.
  3. Run Setup.exe from the SQL Server 7.0 directory of software compatible with your processor architecture.
  4. Specify a shared drive controlled by the primary node of the cluster where you want SQL Server to be installed, in the SQL Server Installation Path dialog box, and in the Master Database Installation Path dialog box.

    Named Pipes is required only for installing SQL Server and SQL Server Cluster Setup. If you want to use another network protocol for normal business operations, ensure that it is also selected.

  5. Start SQL Server, check the installation, and then stop SQL Server. The installation program will install the necessary SQL Server management tools to the local drive. In the event of a failover, you will be able to manage the SQL Server virtual server through normal graphical user interface (GUI) operations.
  6. On the Start menu, point to Programs/Microsoft SQL Server 7.0/Failover, and then click Failover Cluster Wizard.
  7. Select from these options.
Use this option To do this
Install virtual server Install a virtual server.
Remove virtual server Select the name of the virtual server to remove.
Enter the sa password for SQL Server on this computer Enter the sa password.
Enter the password for this SQL Server user account Enter the password for this domain account..
Enter the IP address Enter the static IP address you want clients to use to access this occurrence of SQL Server virtual server.
Enter the Subnet Mask Enter the Subnet Mask IP Address you want clients to use to access this occurrence of SQL Server virtual server.
Enter the server name you want clients to use to access SQL Server virtual server Enter the SQL Server virtual server name (not the cluster or node name) you want clients to use to access this occurrence of SQL Server virtual server.

  1. Confirm your choices, or click Backup to make the necessary corrections.

After you finish, the secondary node is now the backup node for SQL Server.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.