Configuring Microsoft SQL database clustering

To configure Microsoft SQL database clustering:

1. Configure DBSRV-1 as the primary node:
   1. On DBSRV-1, execute the SQL Server installer that you downloaded. The installer file downloads additional files, which you extract at a later point.
   2. Select New SQL Server failover cluster installation.
   3. An installation wizard launches. Proceed through the wizard:
      1. On the Instance Configuration page, enter the computer name for the cluster in the SQL Server Network Name field. This is tied to the Microsoft SQL virtual IP address (VIP), which you configure later.
      2. In the example, Default instance is selected. If desired, you can select Named instance. Click Next.
      3. On the Cluster Disk Selection page, select the desired virtual disk. Click Next.
      4. On the Cluster Network Configuration page, configure the database VIP. Click Next.
      5. On the Server Configuration page, configure the relevant account for services and processes to use. This example uses an Active Directory (AD) administrator account. Using a service account is recommended in a production environment. Click Next.

         

      6. On the Database Engine Configuration page, configure the account to use as the database engine administrator. This example uses AD authentication mode. Click Next.

         

      7. Continue through the wizard to install SQL Server.
   4. On the AD server, you can view that a computer account is created and that it is tied to the database VIP.
2. On DBSRV-2, execute the SQL Server installer that you downloaded.
3. Select Add node to a SQL Server failover cluster.
4. Verify the configuration:
   1. On any database server, in Failover Cluster Manager, go to Roles. Verify that DBSRV1 is the SQL server current primary node.
   2. Ensure that the database cluster status shows as running.
   3. If desired, bring down DBSRV-1 to ensure that the failover happens.