Install SQL Server onto the Clustered Configuration

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

Install SQL Server onto the Clustered Configuration

Follow these procedures to install Microsoft SQL Server 2005 and Service Pack 1 (SP1) onto the Microsoft 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 1

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 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. Click Start, point to Administrative Tools, and then click Cluster Administrator.
  3. Under Groups, right-click on the cluster group name containing the Cluster Name cluster resources, point to New, and then click Resource.
  4. In New Resource, in the Name box, type Distributed Transaction Coordinator.
  5. In the Resource type list, select Distributed Transaction Coordinator.
  6. In the Group list, ensure that the appropriate cluster group name was selected in step 3, and then click Next.
  7. Verify that all nodes appear in the Possible owners list, and then click Next.
  8. Select the shared Physical Disk and Cluster Name resources, and then click Add to add them to the Resource dependencies list.
  9. Click Finish.

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 DWSPV.15: To enable inbound and outbound DTC access on MPSSQL01

  1. On MPSSQL01, click Start, point to All Programs, point to Administrative Tools, and then click Component Services.
  2. Expand Component Services, and then expand Computers.
  3. Right-click My Computer, and then select Properties.
  4. Select the MSDTC tab.
  5. Click Security Configuration.
  6. Select the Network DTC Access check box. In the Transaction Manager Communication section, select the Allow Inbound and Allow Outbound check boxes . Leave all other options as default. Click OK to save the settings.
  7. Click Yes when warned that the MSDTC service will be stopped and restarted. Click OK when the the MSDTC service has been restarted.
  8. Click OK to close the Properties window.

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

Procedure 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 you to 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 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 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.

    Important

    Make sure 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.

  3. If your server supports Autorun, the CD will launch 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.

  4. Read and accept the End User License Agreement.

  5. On the Installing Prerequisites page, review the list of software components that will be installed prior to installing SQL Server, and then click Install.

  6. After the required prerequisites have been installed successfully, click Next.

  7. On the Welcome to the Microsoft SQL Server Installation Wizard page, click Next.

  8. On the System Configuration Check page, review the configuration details for warnings or errors. If there are any errors or warnings in the list (other than IIS Feature Requirement), read the message associated with the error, and then rectify the problem. When you no longer have any errors displayed in the list, click Next to continue the installation.

    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.

  9. On the Registration Information page, enter information in the Name and Company boxes, enter your Product key if prompted to do so, and then click Next.

  10. On the Components to Install page, select SQL Server Database Services and Create a SQL Server failover cluster, and then click Advanced.

  11. Expand Client Components, click Management Tools, and then click Will be installed on local hard drive. Click Next.

  12. On the Instance Name page, ensure that Default Instance is selected, and then click Next.

  13. On the Virtual Server Name page enter MPSSQLVS01, and then click Next.

  14. On the Virtual Server Configuration page, enter the IP address that will be used for the virtual server, and then select the cluster network to be used on the Network to use drop-down list. When complete, click Add. Your entries will appear in the window at the bottom of the window. You may add more than one IP address at this time. Click Next to continue.

  15. On the Cluster Group Selection page, choose the Cluster Group associated with an appropriate data file location on your clustered disk resources.

  16. On the Cluster Node Configuration page, you can add or delete cluster nodes from the virtual server definition. Ensure that all clustered servers running SQL Server are listed as configured nodes, and then click Next. If not, add MPSSQL01 or MPSSQL02 as appropriate.

  17. On the Remote Account Information page, enter the password for your user account.

  18. On the Service Account page, enter the credentials for the MPSSQLService user account in the Fabrikam domain.

  19. On the Domain Groups for Clustered Services page, enter the three group names you created in the previous procedure "To create domain groups for clustered services": ClusteredSQLServer, ClusteredSQLAgent, and ClusteredFullTextSearch.

  20. On the Authentication Mode page, select Windows Authentication, and then click Next.

  21. On the Collation Settings page, choose the SQL Server collations that meet your compatibility requirements. For this reference architecture, accept the default value of Dictionary order, case-insensitive, for use with 1252 Character Set, and then click Next.

  22. On the Error and Usage Report Settings page, choose any settings you like.

  23. Finish the installation, accepting defaults.

Install SQL Server 2005 Service Pack 1

In this procedure you install SQL Server 2005 Service Pack 1 using all the defaults. In order to install SP1 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 SP1 on MPSSQL01 will also update MPSSQL02.

Procedure DWSPV.19: To install SQL Server 2005 Service Pack 1 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. On the Welcome page, confirm the features being upgraded, and then click Next to begin the upgrade process.

  3. Read and accept the End User License Agreement.

  4. On the Feature Selection page, click Next.

  5. On the Authentication Mode page, ensure that All Instances and Windows Authentication are selected, and then click Next.

  6. On the Remote User Account page, enter credentials for the Domain Administrator.

  7. On the Ready to install page, click Install to continue.

    Note

    • You may receive a message regarding pending file operations requiring a reboot. If you encounter this message, click Yes, and then proceed with the installation process.
    • You may get one or more messages reading Locked Filed Found. Because you will be reboot the servers running SQL Server at the end of the installation process, it is safe to click Continue.
  8. If you are prompted to reboot your server, click OK.

  9. On the Installation Complete page, ensure the installation was successful, and then click Finish to end the upgrade process.

  10. To complete the SQL Server 2005 Service Pack 1 installation, reboot MPSSQL01 and MPSSQL02 .