Follow these procedures to install Microsoft SQL Server 2005 and Service Pack 2 (SP2) onto the Windows Server 2003 cluster that will eventually host the Microsoft Provisioning System (MPS) databases.

Tasks

  1. Install MSDTC on the SQL Server 2005 Cluster
  2. Create Domain Groups for Clustered Services
  3. Install SQL Server 2005 onto the Cluster
  4. Install SQL Server 2005 Service Pack 2

Install MSDTC on the SQL Server 2005 Cluster

Microsoft Distributed Transaction Coordinator (MSDTC) must be installed as a cluster resource in order for cluster node failover of the server running SQL Server to work properly.

Procedure W03-DWSPV.14: To install MSDTC as a cluster resource

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

  2. In Cluster Administrator, under Groups, right-click the cluster group name containing the Cluster Name cluster resources, point to New, and then click Resource.

  3. Follow the on-screen instructions to create the MSDTC cluster resource on MPSSQL01.

For more information, see Creating an MSDTC Cluster Resource.

Inbound and outbound network DTC access must be enabled in order for the MPS servers to communicate over the network with the computers running SQL Server.

Procedure W03-DWSPV.15: To enable inbound and outbound DTC access on MPSSQL01

  1. On MPSSQL01, open the Component Services console from Administrative Tools.

  2. Expand Component Services, and then expand Computers. Right-click My Computer and select Properties to open the My Computer Properties page.

  3. On the MSDTC tab, click Security Configuration and verify the following information:

    • Ensure the Network DTC Access, Allow Inbound and Allow Outbound check boxes are selected
    • All other options are left as default.
  4. Follow the prompt to restart the MSDTC service.

Both cluster nodes must be online before continuing with the installation.

Procedure W03-DWSPV.16: To bring the clustered resources online

  1. On MPSSQL01, open Cluster Administrator.

  2. Right-click Cluster Group, and then select Bring Online.

  3. Verify that all SQL Server resources come online successfully, including the Distributed Transaction coordinator.

Create Domain Groups for Clustered Services

The clustered SQL Server 2005 installation requires that you create several groups in Active Directory directory service. In this procedure you create three global groups.

For more information and best practices on this procedure, see KB915846: Best practices for setting up domain groups when you install a SQL Server 2005 cluster.

Procedure W03-DWSPV.17: To create domain groups for clustered services

  1. Log on to AD01 as a member of the Domain Admins group.

  2. Start Active Directory Users and Computers. Navigate to the Users container.

  3. Create three new Global Security groups called ClusteredSQLServer, ClusteredSQLAgent, and ClusteredFullTextSearch.

Install SQL Server 2005 onto the Cluster

In this procedure you install SQL Server 2005 onto the cluster. Use mainly the defaults, installing database services with failover clustering, and also installing the SQL Server management tools.

Procedure W03-DWSPV.18: To install SQL Server 2005 onto the Windows Server 2003 cluster

  1. Log on to MPSSQL01 as a member of the Domain Admins group.

    Note:
    Make sure that you are not logged on to any console or terminal session on any other cluster member server with this account, or the installation will fail.
  2. Insert the SQL Server 2005, Standard Edition CD. If your server supports Autorun, the CD will start the installer and display the Microsoft SQL Server 2005 splash screen. Click Install Server components, tools, Books Online, and samples. If your server does not support Autorun, browse to the Servers directory on the CD and run Setup.exe.

  3. Follow the instructions to install SQL Server 2005. Ensure the following settings:

    • On the Components to Install page, select SQL Server Database Services and Create a SQL Server failover cluster, and then click Advanced. Expand Client Components, click Management Tools, and then click Will be installed on local hard drive.
    • On the Instance Name page, ensure that Default Instance is selected.
    • Use MPSSQLVS01 as the Virtual Server Name for this reference architecture.
    • On the Cluster Node Configuration page, ensure that all clustered servers running SQL Server are listed as configured nodes. If not, add MPSSQL01 or MPSSQL02 as appropriate.
    • On the Service Account page, enter the credentials for the MPSSQLService user account in the Fabrikam domain
    • On the Domain Groups for Clustered Services page, enter the three group names (ClusteredSQLServer, ClusteredSQLAgent, and ClusteredFullTextSearch) created in the previous procedure.
    Note:
    A warning message for the IIS Feature Requirement appears because Internet Information Services (IIS) has not been installed. This error message is expected and it is safe to continue with the installation.

For more information about installation instructions, see How to: Create a New SQL Server 2005 Failover Cluster (Setup).

Install SQL Server 2005 Service Pack 2

In this procedure you install SQL Server 2005 Service Pack 2 using all the defaults. In order to install SP2 onto the second node, specify the domain administrator as the user account to use to connect to the server.

Note:
The installation of SQL Server 2005 SP2 on MPSSQL01 will also update MPSSQL02.

Procedure W03-DWSPV.19: To install SQL Server 2005 Service Pack 2 onto the cluster

  1. Ensure that you are logged on to MPSSQL01 using an account that is a member of the domain administrators group.

  2. Insert the service pack media. Follow the instructions to perform a default installation of SQL Server 2005 Service Pack 2.

  3. To complete the SQL Server 2005 Service Pack 2 installation, restart MPSSQL01 and MPSSQL02.