Clustering SQL 2000 Part III

Assuming that you completed the steps described in the previous installment of this article, you are now ready to begin the installation of SQL Server 2000. The following list outlines the basic steps involved in creating a failover cluster. Unlike the clustering of Exchange Server, where the virtual server is created after the installation of the application, the virtual server for an instance of SQL Server 2000 is created during setup.

To create a new SQL failover cluster:

  1. Insert the SQL Server CD and click Next at the Welcome screen.
  2. From the Computer Name window, type a name for the virtual server. If setup detects Cluster Service is running, the Virtual Server option is the default. Click Next.
  3. Enter the username and company name. Click Next.
  4. Click Yes to accept the Licensing Agreement.
  5. From the Failover Clustering window, select the network from which clients will be accessing the virtual server and enter in an IP address from the virtual server. You can enter in multiple IP addresses if the virtual server needs to be accessible to clients on different subnets. Click Next.
  6. From the Cluster Disk Selection window, select the appropriate disk group. This is where the data files for this instance of SQL will be located. Click Next.
  7. From the Cluster Management window, remove any nodes that will not be part of the failover cluster by selecting the node and clicking Remove. Click Next.
  8. The Remote Installation window will appear. Enter in a username and password for the remote cluster node. The user account specified must have administrative privileges on the node. Click Next.
  9. From the Instance Name screen, choose the type of instance – default or named. You can specify a named instance by simply clearing the Default checkbox. Click Next.
  10. Select the type of installation from the Setup Type window. Click Next.
  11. From the Services Account window, select the account that the failover cluster will run under. Click Next.
  12. From the Authentication Mode window, choose the authentication type – Windows authentication mode or mixed mode. Click Next.
  13. Click Next at the Setup Copying Files window. Click Finish.

You can create a second instance of SQL Server 2000 on the same cluster node by repeating the steps described above.