Configure Windows Server 2003 Clustering

Cc526734.chm_head_left(en-us,TechNet.10).gif Cc526734.chm_head_middle(en-us,TechNet.10).gif Cc526734.chm_head_right(en-us,TechNet.10).gif

Configure Windows Server 2003 Clustering

The following procedures are required to configure Microsoft Windows Server 2003 clustering for your Microsoft Provisioning System (MPS) database servers (MPSSQL01, MPSSQL02).

Tasks

  1. Create a Service Account on the Domain Controller
  2. Install a New Server Cluster
  3. Add Nodes to the Server Cluster
  4. Optimize Cluster Configuration
  5. Add MPSSQLService to the Local Administrators Group

Create a Service Account on the Domain Controller

You will need to create a service account for cluster communications.

Procedure DWSPV.5: To create a service account on the domain controller

  1. Log on to AD01 using an account that is a member of the Domain Administrators group.
  2. On the taskbar, click Start, point to Administrative Tools, and then click Active Directory Users and Computers.
  3. Expand fabrikam.com.
  4. Right-click Users, point to New, and then click User.
  5. In the New Object-User dialog box, type MPSClusterAdmin as the First name and the User logon name, and then click Next.
  6. In the next New Object - User dialog box, clear the User must change password at next logon check box. Enter the password twice, and then select Password never expires.
  7. Click Next. Verify the information you have entered, and then click Finish. Note The service account cannot have a blank password or a password that will expire.

Install a New Server Cluster

In this section you set up the Windows Server 2003 cluster on MPSSQL01. Note that MPSSQL02 needs to be shut off during this procedure.

Procedure DWSPV.6: To install a new server cluster

  1. Ensure that MPSSQL02 has been shut down.

  2. Log on to MPSSQL01 using an account that is a member of the Domain Administrators group.

  3. In the Administrative Tools folder, open the Cluster Administrator.

  4. In the Open Connection to Cluster dialog box, select Create New Cluster.

  5. Click OK to launch the New Server Cluster Wizard.

  6. Click Next. The Cluster Name And Domain page appears.

  7. Confirm the domain name, enter the unique name for the cluster (MPSSQLCluster), and then click Next.

  8. On the Select Computer page, enter MPSSQL01 in the Computer Name field, and then click Next.

  9. On the Analyzing Configuration page, confirm that the progress bar is displayed, indicating that there are no significant problems.

    Note

    If you have any problems at this stage, resolve them now before proceeding with creating the cluster. Click View Log for further information.

  10. Click Next to open the IP Address page. Enter the unique cluster address, which will be used by management tools to connect to the cluster, and then click Next.

  11. On the Cluster Service Account page, type MPSClusterAdmin for the account name, enter the correct secure password for this account, and then confirm the domain name. This account will be granted local administrative privileges on all nodes in the cluster. Click Next.

  12. Confirm the information on the Proposed Cluster Configuration page. Click Quorum, and then verify that the correct drive has been chosen as the quorum disk. Click OK to close the Quorum dialog box, and then click Next to start creating the cluster.

    Note

    When the Creating the Cluster page appears, you can click View Log or Details for further information on cluster creation progress.

  13. When the Cluster Creation task completes, click Next. The final page of the Cluster Creation Wizard appears. Click Finish to exit the wizard.

    The Cluster Administrator application appears, displaying the newly created cluster.

Add Nodes to the Server Cluster

Next, you add the second node, MPSSQL02, to the cluster.

Procedure DWSPV.7: To add nodes to the server cluster

  1. Turn on MPSSQL02. Wait for it to fully start.
  2. Right-click the root cluster container, which is named with the name of your cluster. Click New, and then click Node.
  3. When the Add Node dialog box appears, click Next.
  4. On the Select Computer page, in the Computer Name field, enter the name of the second cluster node, MPSSQL02, to add it to the cluster . Click Add to add it to the list of Selected Computers. Click Next.
  5. On the Analyzing Configuration page, confirm that the progress bar appears, indicating that there are no significant problems. Note If you have any problems at this stage, resolve them now before proceeding with creating the cluster. Click View Log for further information.
  6. Click Next to open the Cluster Service Account page. Enter the password previously chosen for the MPSClusterAdmin account. Ensure that fabrikam.com is selected as the domain. Click Next, and then click Next again. Note When the Creating the Cluster page appears, you can click View Log or Details for further information on cluster creation progress.
  7. Click Next, and the final page of the Add Node Wizard appears. Click Finish to exit the wizard.

Procedure DWSPV.8: To configure the public network connections for MPSSQL01 and MPSSQL02

  1. In Control Panel, double-click Network Connections.
  2. In Network Connections, right-click <Network connection name> (where <Network connection name> is the name of your public network connection), and then click Rename.
  3. In the Name field, enter a meaningful name, such as Public.

Procedure DWSPV.9: To configure the private network connections for MPSSQL01 and MPSSQL02

  1. In Network Connections, right-click <Network connection name> (where <Network connection name> is the name of your private network connection), and then click Rename.
  2. In the Name field, enter a meaningful name, such as Private.
  3. In Network Connections, right-click Private, and then click Properties.
  4. In Private Properties, on the General tab, select Internet Protocol (TCP/IP), File and Printer Sharing for Microsoft Networks, and Client for Microsoft Networks.
  5. Select Internet Protocol (TCP/IP), and then click Properties.
  6. In Internet Protocol (TCP/IP) Properties, select Use the following IP address, and then configure a static IP address and subnet mask for the connection. Also select Use the following DNS server addresses, leave blank the IP address fields for Preferred DNS server and Alternate DNS server, and then click Advanced.
  7. In Advanced TCP/IP Settings, on the DNS tab, verify the following information:
    • Under DNS server addresses, in order of use, ensure that no addresses are listed.
    • Make sure that the Register this connection's addresses in DNS check box is cleared.
  8. On the WINS tab, ensure that Disable NetBIOS over TCP/IP is selected.
  9. Click OK twice to save the changes, and then click Close to exit Properties.

Procedure DWSPV.10: To configure the network connection order for MPSSQL01 and MPSSQL02

  1. In Control Panel, double-click Network Connections.
  2. On the Advanced menu, click Advanced Settings.
  3. In Advanced Settings, on the Adapters and Bindings tab, under Connections, make sure that your connections appear in the following order:
    • Public
    • Private
    • Remote access connections
  4. Click OK to save the changes.

Optimize Cluster Configuration

In this procedure you specify what interfaces the cluster will use for cluster communication.

Procedure DWSPV.11: To optimize cluster settings

  1. On MPSSQL01, in Cluster Administrator, on the left pane, expand Cluster Configuration, click Networks, right-click the private network interface, and then click Properties.
  2. Select Internal cluster communications only (private network). Click OK.
  3. Right-click the Public network interface, and then click properties. Verify that All communications (mixed network) is selected.
  4. In the left pane of cluster administrator, right-click the cluster name (MPSSQLCLUSTER), and then click Properties.
  5. On the Network Priority tab, change the order of the interfaces so that the private interface is listed first. Click OK.

Procedure DWSPV.12: To create a Microsoft SQL Server service account on the domain controller

  1. On AD01, open Active Directory Users and Computers and expand fabrikam.com.
  2. Right-click Users, point to New, and then click User.
  3. In the New Object-User dialog box, type MPSSQLService as the First name and the User logon name, and then click Next.
  4. In the next New Object - User dialog box, clear the User must change password at next logon check box. Enter the password (twice), and then select Password never expires.
  5. Click Next. Verify the information you have entered, and then click Finish. Note The service account cannot have a blank password or a password that will expire.

Add MPSSQLService to the Local Administrators Group

The MPSSQLService account needs to be an administrator on both cluster nodes. On each of the cluster nodes, use the Computer Managment Microsoft Management Console (MMC) to add the MPSSQLService user account to the Administrators group.

Procedure DWSPV.13: To add MPSSQLService to the local Administrators group

  1. Log on to MPSSQL01 as a member of the domain administrators group.
  2. In Administrative Tools, click Computer Management.
  3. Expand Local Users and Groups, and then click Groups.
  4. Double-click Administrators.
  5. Click Add, and then type MPSSQLService. Click Check Names to make sure that the name resolves, and then click OK.
  6. Click OK to close the Administrator Properties window.
  7. Repeat these steps on MPSSQL02.