Dell™ PowerEdge™ Systems Dell | Microsoft® SQL Server 2005 Standard Edition with SP2 Database on Microsoft® Windows Server® 2003 R2 Standard Edition or Enterprise Edition with SP2 Deployment Guide Version 1.1 w w w. d e l l . c o m | s u p p o r t . d e l l .
Notes and Notices NOTE: A NOTE indicates important information that helps you make better use of your computer. NOTICE: A NOTICE indicates either potential damage to hardware or loss of data and tells you how to avoid the problem. ____________________ Information in this document is subject to change without notice. © 2007 Dell Inc. All rights reserved. Reproduction in any manner whatsoever without the written permission of Dell Inc. is strictly forbidden.
Contents Software and Hardware Requirements License Agreements . . . Important Documentation. . . . . . . . . . . . . . . . . . . . . . . 5 . . . . . . . . . . . . . . . . . . . . . . . . . . 5 5 . . . . . . . . . . . . . . . . . . . . . . . . . . Installing and Configuring the Operating System . . . . . . . . . . . . . . . . . Using the Dell™ PowerEdge™ Installation and Server Management Media to Perform a Clean Installation of the Operating System . . . .
Preparing the Disks for Installing the SQL Server 2005 Database . . . . . . . 25 Verifying Hardware and Software Configurations . . . . . . . . . . . . . . . 26 Configuring MSCS Clustering for SQL Server 2005 . . . . . . . . . . . . . . . 26 . . . . 26 . . . . . . . . 26 27 28 28 . . . . . . . . . . . . . . . . . . . . . . 29 Verifying Cluster Readiness . . . . . . . . . . . . . . . . . . . . Configuring Microsoft Cluster Service (MSCS) With Window s Server 2003 . . . . . . . . . . . . . . .
This document provides information for installing and configuring the Microsoft® SQL Server™ 2005 Standard Edition with SP2 software following Dell’s recommended configurations for SQL Server 2005.
Installing and Configuring the Operating System This section provides information about installing and configuring the Windows Server 2003 R2 Standard or Enterprise Edition with SP2 operating system for SQL Server 2005 deployment. This Deployment Guide requires a companion Dell Database Resource CD to complete the installation on EMC Fibre Channel Storage. Please download the Dell Database Resource CD from dell.com/sql.
b If you agree with all of the information, click Accept to continue. c If you do not agree with all the information, click Decline. NOTE: When you click Decline, your system will restart and you will not be able to complete the operating system installation. 7 Click Server OS Installation for Server Setup to install the operating system. The Set the Date and Time window appears. 8 Select the appropriate date, time, and time zone; then, click Continue. The Operating System to Install window appears.
The Dell OpenManage Server Assistant automatically detects the CD and begins copying the operating system files. NOTE: This procedure may take several minutes to complete. 17 When prompted, remove the CD from the CD drive, and click Finish. Your system automatically restarts, Windows Setup appears in text mode, and the installation continues. NOTE: If Console Redirection is enabled in the System Setup program, you are prompted for an administrator password in the text mode of Windows Setup.
3 If you agree with the information, accept the license terms and click Next. NOTE: If you do not agree with the information in the End-User License Agreement, click Cancel. Installation of the optional R2 components will terminate. The Setup Summary window appears. 4 Click Next. The Completing Windows Server 2003 R2 Setup window is displayed. 5 Click Finish.
3 Select the R2 components you want to install, and follow the prompts on the screen to complete the installation. Installing Internet Information Services (IIS) using the Windows Server 2003 SP2 CD This section is only required if you want to install Internet Information Server (IIS) on the same system with SQL Server 2005. The IIS server is required for advanced SQL Server 2005 features such as Reporting and Analysis Services. For SQL installation requirements, see www.msdn2.microsoft.
h Specify a name (for example, Public) for the NIC team and click Next. i In the Select the Adapters to include in this Team box, select the remaining network adapters you identified for NIC teaming and click Next. j From the Select a team Mode list, select Adaptive Load Balancing and click Next. k Click Finish to complete the teaming. l The Team: Properties window displays. m Click OK. n Click OK to close the Properties window.
Configuring the IP Addresses for Your Public Network Adapters Use the following procedure to configure the IP addresses for the public network adapters. The network adapter status displays in the system tray after you perform the procedures in this section. 1 Update the adapter’s network interface name, if required. Otherwise, go to step 2. a Click Start and navigate to Settings → Control Panel → Network Connections.
b At the command prompt, type: ping where is the IP address of the network gateway. If the node’s network adapter does not respond to ping commands, check your network configuration and then repeat this step. Configuring the IP Addresses for Your Private Network Adapters If you are installing a SQL Server 2005 cluster, each node will require a static IP address for the private (heartbeat) network.
3 Add the public IP address and the host name file: %SystemRoot%\System32\drivers\etc\hosts NOTE: Add the private IP address to the hosts file only if it is not registered with DNS. 4 Ensure that the node can communicate with the public network. 5 Open a command prompt window. 6 Verify that the network adapter responds to the following ping commands.
Figure 1-1. Hardware Connections in a Dell Solution for SQL Server 2005 Clients or Application Servers PowerEdge Server(s) for SQL Server 2005 Optional SAN Fabric Dell PowerVault or Dell EMC Storage Array Table 1-1. Hardware Interconnections for a Direct-attached SAS Storage Component Connections Each PowerEdge Server One CAT5e/6 cable from the NIC to the public local area network (LAN). If clustered, one CAT5e/6 cable from an additional NIC to the private (heartbeat) local area network (LAN).
Cabling the Storage Systems This section provides information for connecting your cluster to a storage system. Storage management can be either in-band through the SAS connection, or out-of-band using an Ethernet connection. For out-of-band storage management, cable the Ethernet ports on the storage array to the public network. NOTE: Dell recommends that you configure your Dell PowerVault MD3000 to use both in-band and out-of-band management paths.
Cabling the Cluster in Redundant Configuration With Single SAS 5/E HBAs Each cluster node attaches to the storage system using one SAS 5/E HBA and two SAS cables. In this configuration, there are redundant storage paths from the cluster node to the storage system.
Cabling the Cluster in Redundant Configuration With Dual SAS 5/E HBAs Each cluster node attaches to the storage system using two SAS 5/E HBAs and two SAS cables. In this configuration, there are redundant storage paths from the cluster node to the storage system.
Cabling the Dell|EMC Fibre Channel Storage Systems This section provides information for connecting your standalone server and cluster server to a storage system in a direct-attached or in a SAN-attached configuration. Cabling configuration in a Direct-Attached environment A direct-attached configuration consists of redundant Fibre Channel host bus adapter (HBA) ports cabled directly to a Dell|EMC storage system.
Figure 1-5. Cabling the Server Direct-attached to a CX3-20 Storage System Using two Single Port FC HBAs. Cabling the Cluster Servers Each cluster node attaches to the storage system using two fiber optic cables with duplex local connector (LC) multimode connectors that attach to the HBA ports in the cluster nodes and the storage processor (SP) ports in the Dell|EMC storage system.
NOTE: The cables are connected to the storage processor ports in sequential order for illustrative purposes. While the available ports in your storage system may vary, HBA port 0 and HBA port 1 must be connected to SP-A and SP-B, respectively. Figure 1-6.
The switches, the HBA ports in the cluster nodes, and the SP ports in the storage system use duplex LC multimode connectors. The connectors consist of two individual fiber optic connectors with indexed tabs that must be inserted and aligned properly in the small form-factor pluggable (SFP) module connectors on the Fibre Channel switches and the connectors on the cluster nodes and storage systems. Each HBA port is cabled to a port on a Fibre Channel switch.
Cabling the Cluster Servers 1 Connect cluster node 1 to the SAN. a Connect a cable from HBA port 0 to Fibre Channel switch 0 (sw0). b Connect a cable from HBA port 1 to Fibre Channel switch 1 (sw1). 2 Repeat step 1 for each node. 3 Connect the storage system to the SAN. a Connect a cable from Fibre Channel switch 0 (sw0) to SP-A port FE 0. b Connect a cable from Fibre Channel switch 0 (sw0) to SP-B port FE 1. c Connect a cable from Fibre Channel switch 1 (sw1) to SP-A port FE 1.
Table 1-2 and Table 1-3 show a simple layout for a two physical processor system. Table 1-2. Storage LUN Layout Storage Processor Virtual Disks SPA TEMPDB, DATA2, QUORUM SPB DATA1, LOGS Table 1-3.
NOTE: Applications utilizing SQL Server as a back end may have specific requirements dictated by the design characteristics of the application and are beyond the scope of this Deployment Guide. For application-specific guidelines and recommendations as they relate to physical and logical database layout, please contact your application provider.
9 Use the following procedure to format all external disks to NTFS. a In the Disk Management window, right-click the partition area and choose Format. b Enter volume label (optional) in the Volume label field. c Choose NTFS in the File system pull down menu. d Choose 64K in the Allocation unit size pull-down menu. e Click OK. f Click OK when the format warning message displays. g Close the Computer Management window.
3 In the Action box of Open Connection to Cluster window, select Create new cluster. The New Server Cluster Wizard window appears. 4 Click Next to continue. 5 Follow the procedures in the wizard, and then click Finish. 6 Add the additional node(s) to the cluster. a Turn on the remaining node(s). b Click the Start button, select Programs→ Administrative Tools, and then double-click Cluster. c Click Administrator. d From the File menu, select Open Connection.
The Add Nodes Wizard verifies and underlines each valid system name. 7 Click OK. 8 In the Select Computers menu, click Add. 9 In the Advanced Configuration Options window, click Advanced (minimum) configuration, and click OK. 10 In the Add Nodes window, click Next. NOTE: In the Analyzing Configuration menu, Cluster Administrator analyzes the cluster configuration. If Cluster Administrator discovers a problem with the cluster configuration, a warning icon appears in the Checking Cluster Feasibility window.
Follow these steps to create a resource group for SQL Server 2005 that contains all of the data, log, and tempdb disks that will be used by the clustered SQL Server instance: 1 Right-click one of the groups and rename to SQL Server. 2 Identify the disks that should be in the SQL Server Group from the other additional groups, and move each additional disk by clicking and dragging to the SQL Server Group. The goal is to have all available SQL disks on one Resource Group.
3 In the Control Panel window, double-click Administrative Tools. 4 In the Administrative Tools window, double-click Local Security Settings. 5 In Local Security Settings window, expand Security Settings, and then expand Local Policies. 6 Select the User Rights Assignment folder. The policies will be displayed in the details pane. 7 In the pane, double-click Perform Volume Maintenance Tasks. 8 On the Local Security Setting tab, click Add.
7 On the System Configuration Check page, the system is scanned for conditions that may block setup. Make sure all the requirements are met successfully. To proceed with setup after the scan completes, click Next. 8 On the Registration Information page, enter information in the Name and Company text boxes, enter your 25-character product key and click Next. 9 On the Components to Install page, select the components for your installation.
16 On the Service Account page, select Use the built-in System account. To use a domain user account, select Use a domain user account and enter the username, password and domain name. NOTE: The domain name cannot be a fully qualified Domain Name System (DNS) name. For example, if your DNS name is domain-name.com, use domain-name in the Domain field. SQL Server 2005 does not accept domainname.com in the Domain field.
29 If you are instructed to restart the computer, do so now. Be sure to read the message from the Setup program when you complete the installation. NOTE: Failure to restart the computer may cause failures when you run the Setup program in the future. Installing Service Pack 2 for the SQL Server 2005 Database 1 Close all applications before proceeding. 2 Right-click My Computer and select Manage. 3 Expand Services and Applications. 4 Select Services.
18 In the Additional Information window, click Finish. 19 Reboot the computer. Additional Information For SQL Server 2005 database best practices, please refer to the Reference Architecture White paper on dell.com/sql.
Index C I networking, configuring, 10 configuring data throughput, 14 file initialization, 29 IP addresses, 12-13 network adapter, 10 networking, 10 NIC teaming, 10 IIS installing, 10 server, 10 NIC, 10 configuring teaming, 10 D data files, 29 throughput, 14 installing IIS, 10 operating system, 6 service pack 2, 33 Internet Information Services see IIS IP addresses configuring, 12-13 network adapter, 12-13 requirements, 10 F L file initialization, 29 license agreements, 5 files data, 29 hosts, 1
Index 36 Index