Dell Microsoft SQL Server 2005 Owner's Manual

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

www.dell.com | support.dell.com

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.

____________________

Reproduction in any manner whatsoever without the written permission of Dell Inc. is strictly forbidden. Trademarks used in this text: Dell, the DELL logo, PowerEdge, and PowerVault are trademarks of Dell Inc.; Intel and Xeon are registered

trademarks of Intel Corporation; Microsoft, Windows, and Windows Server are either trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.

Other trademarks and trade names may be used in this document to refer to either the entities claiming the marks and names or their products. Dell Inc. disclaims any proprietary interest in trademarks and trade names other than its own.

December 2007 Rev. A02

Software and Hardware Requirements . . . . . . . . . . . . . . . . . . . . . . 5

License Agreements

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5

Important Documentation

. . . . . . . . . . . . . . . . . . . . . . . . . . . 5

Installing and Configuring the Operating System

. . . . . . . . . . . . . . . . . 6

Using the Dell™ PowerEdge™ Installation and Server Management Media to Perform a Clean Installation of the Operating System

Installing Microsoft Windows Server 2003 R2, Standard or Enterprise Edition with SP2 Using the Dell PowerEdge Installation and Server Management CD

Installing the R2 Components

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6

. . . . . . . . . . . . . . . . . . . . . . . . . 8

Installing Internet Information Services (IIS) using the Windows Server 2003 SP2 CD

Configuring Networking for SQL Server 2005

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10

. . . . . . . . . . . . . . . . . . 10

Configuring NIC Teaming for Your Public Network Adapters Configuring the IP Addresses for Your Public Network Adapters Configuring the IP Addresses for Your Private Network Adapters Configure Network Interface for Maximizing Data Throughput

Configuring External Storage for SQL Server 2005

Hardware Overview for Standalone SAS

Cabling the Storage Systems

. . . . . . . . . . . . . . . . . . . . . . . . . . 16

. . . . . . . . . . . . . . . 14

. . . . . . . . . . . . . . . . . . 14

Cabling the Standalone Server in Redundant Configuration With Dual SAS 5/E HBAs

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16

Cabling the Cluster in Redundant Configuration With Single SAS 5/E HBAs

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17

Cabling the Cluster in Redundant Configuration With Dual SAS 5/E HBAs

Cabling the Dell|EMC Fibre Channel Storage Systems Cabling configuration in a Direct-Attached environment Cabling the Cluster Servers Cabling Configurations in a SAN-Attached Environment Cabling a Stand-alone Server Cabling the Cluster Servers Setting Up Your Storage Array Installing the Host-Based Software Needed for Storage

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18

. . . . . . . . . . . 19

. . . . . . . . . 19

. . . . . . . . . . . . . . . . . . . . . . . . . 20

. . . . . . . . . 21

. . . . . . . . . . . . . . . . . . . . . . . 22

. . . . . . . . . . . . . . . . . . . . . . . . . 23

. . . . . . . . . . . . . . . . . . . . . . . 23

. . . . . . . . . 25

. . . . . . . 6

. . . . . . . 10

. . . . . 12

. . . . . 13

. . . . . . 14

Contents 3

Preparing the Disks for Installing the SQL Server 2005 Database . . . . . . . 25

Verifying Hardware and Software Configurations

Configuring MSCS Clustering for SQL Server 2005

Verifying Cluster Readiness

. . . . . . . . . . . . . . . . . . . . . . . . 26

. . . . . . . . . . . . . . . 26

Configuring Microsoft Cluster Service (MSCS) With Window s Server 2003

Adding Cluster Nodes Using the Advanced Configuration Option Verifying MSCS Operation Creating a Cluster Resource Group for SQL Server 2005

Installing SQL Server 2005 Database

Pre-Install Preparation Configuring a Windows Account to Enable Instant File Initialization Installing the SQL Server 2005 Database Software Installing Service Pack 2 for the SQL Server 2005 Database

Additional Information

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26

. . . . . 27

. . . . . . . . . . . . . . . . . . . . . . . . . 28

. . . . . . . . . . 28

. . . . . . . . . . . . . . . . . . . . . . 29

. . . . . . . . . . . . . . . . . . . . . . . . . . . 29

. . . 29

. . . . . . . . . . . . 30

. . . . . . . . 33

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34

Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35

4 Contents

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.

The following topics are covered:

• Software and hardware requirements

• Installing and configuring Microsoft

• Configuring networking and storage for SQL Server 2005 database

• Configuring MSCS Clustering for SQL Server 2005

• Installing SQL Server 2005 and software updates

• Additional information

• Troubleshooting

For more information on Dell’s supported configurations for solutions website at dell.com/sql.

If you purchased the SQL Server 2005 Deployment Service, your Dell Professional Services representative will assist you with the following:

• Verifying hardware and software configurations

• Configuring networking and storage

• Installing SQL Server 2005 Standard Edition

• Installing SQL Server 2005 Service Pack 2

Windows Server® 2003 R2 Edition with SP2

SQL Server 2005

, see the Dell|SQL Server

Software and Hardware Requirements

For a list of the minimum supported hardware and software components for this solution, please refer to the Solution Deliverable List (SDL) document on dell.com/sql.

NOTE: Depending on the number of users, the application you use, your batch processes, and other factors,

you may need a system that exceeds the minimum hardware requirements in order to achieve your desired performance. For initial sizing information, please refer to the following link: dell.com/sql.

License Agreements

NOTE: If you do not have a SQL Server 2005 software license, contact your Dell sales representative.

Important Documentation

For more information on specific hardware components, see the documentation that came with your system.

Deployment Guide 5

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.

Using the Dell™ PowerEdge™ Installation and Server Management Media to Perform a Clean Installation of the Operating System

Use the Dell PowerEdge Installation and Server Management CD that shipped along with your server to ensure that all the supported drivers for the Windows operating system are installed.

NOTE: If you purchased a Dell system without an operating system, Dell strongly recommends that you use the

supported version of the Dell PowerEdge Installation and Server Management media to guide you through the operating system installation. The Dell PowerEdge Service and Diagnostic Utilities media contains the latest drivers available at the time you purchased your Dell system. See the Dell Support website at support.dell.com/support/downloads for any updated drivers that were not included on your Dell PowerEdge Service and Diagnostic Utilities media. The Dell Database Resource CD contains software drivers such as EMC Fibre Channel and NIC Teaming that are not included in the Operating System base drivers. Download the Dell Resource CD from dell.com/sql.

NOTE: To update base drivers, use the Dell PowerEdge Service and Diagnostic Utilities media.

The Dell PowerEdge Installation and Server Management media guides you through the operating system installation procedure and installs the Dell-specific device drivers that are not on the operating system media.

NOTICE: During the installation procedure, all data is erased from your hard drive. Dell recommends that you back

up your data before you perform this procedure.

Installing Microsoft Windows Server 2003 R2, Standard or Enterprise Edition with SP2 Using the Dell PowerEdge Installation and Server Management CD

Connect a keyboard, mouse, and monitor to your system.

Turn on your system.

Insert the

Press <Ctrl><Alt><Delete> to restart your system.

If you are not using the

Welcome to Dell OpenManage™ Server Assistant

If you are using the time, perform the following steps:

The

6 Deployment Guide

Dell PowerEdge Installation and Server Management

CD into the CD drive.

Dell PowerEdge Installation and Server Management

window appears. Go to step 7.

Dell PowerEdge Installation and Server Management

When prompted, click the appropriate language for your system.

Dell Software License Agreement

NOTE:

Read the information carefully.

window appears.

CD for the first time, the

CD on your system for the first

If you agree with all of the information, click

If you do not agree with all the information, click

NOTE: When you click Decline, your system will restart and you will not be able to complete the operating

system installation.

Click

Server OS Installation

The

Set the Date and Time

Select the appropriate date, time, and time zone; then, click

The

Operating System to Install

Select

Microsoft Windows Server 2003 x86 Edition Service Pack 2

Click OK, and then click

To set up a new boot partition, select the appropriate file system and size for your partition and click

Continue

NOTICE: If there is an existing partition on the hard drive, the Confirm to delete partition window appears. Click

Continue. Server Assistant deletes all existing partitions on the hard drive.

NOTE: For maximum system security, Dell recommends selecting NTFS File System.

for Server Setup to install the operating system.

window appears.

Continue

Decline

to continue.

Continue

The Network Adapter(s) configuration window appears.

Select one of the following options and click

Obtain IP address from DHCP server.

Specify an IP address

Continue

The Enter Configuration Information Edition window appears.

Type your system information in the appropriate fields and click

Continue

NOTE: By default, the Open Manage Server Assistant (OMSA) check box is selected. This property will prompt for

the OMSA CD that came with your system and install it automatically during the OS install.

NOTE: If you are not using the media provided by Dell, enter the Windows Product Key at this stage.

The Operating System Installation Summary window appears.

If the configuration settings are correct, click

Continue

The Microsoft Windows Installation Wizard window appears. The file copy process starts.

If the configuration settings are not correct, perform the following steps:

Click

Back

until the appropriate screen appears.

Enter the correct information.

Click

Continue

When prompted, insert the

Microsoft Windows Server 2003 R2 Enterprise Edition with SP2 Disk 1

until the

Microsoft Windows Server 2003 R2 Standard Edition with SP2 Disk 1

Microsoft Windows Installation Wizard

window appears.

CD into the CD drive.

Deployment Guide 7

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.

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. Enter an administrator password and press Enter to continue. The Emergency Management System window appears. Click OK to continue.

Windows Setup automatically restarts your system, and the Windows Setup window appears. Windows Setup completes the installation and restarts your system.

In the

Log On

window, type your administrator password, and click OK.

The system prompts you to insert the Microsoft Windows Server 2003 SP2 Disk 2 CD.

NOTE: If you want to install the optional R2 components, click OK and then see the "Installing the R2 Components"

on page 8 to complete the installation.

Click

Cancel

to proceed with the operating system installation without installing the optional R2

components.

The Windows Setup dialog box appears with directions on how to continue with the second CD install at a later time.

Click OK.

The Windows Server Post-Setup Security Updates window appears.

NOTE: At this time, your Windows firewall is disabled. Dell recommends that you update your system with the

latest critical security updates and configure Automatic Updates before you click Finish.

Click

Finish

Click

Yes

to close the window.

The Manage Your Server window appears.

The operating system is now installed on your system. If you need additional information to complete the rest of the installation, see the documentation that came with your software or go to the Microsoft Support website at www.support.microsoft.com.

Installing the R2 Components

Perform the steps below to install the optional R2 components:

Insert the

The Welcome to the Windows Server 2003 R2 Setup Wizard window appears.

Click

The End-User License Agreement window appears.

8 Deployment Guide

Windows Server 2003 R2 Disk 2

CD into the CD drive, and then click OK.

If you agree with the information, accept the license terms and click

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.

Click

The Completing Windows Server 2003 R2 Setup window is displayed.

Click

Finish

The following is a list of optional R2 components available on the Windows Server 2003 R2 Disk 2 CD:

• Active Directory Application Mode

• Active Directory Federation Services

• Identity Management for UNIX

• Distributed File System

• File Server Management

• File Server Resource Manager

• Hardware Management

• Print Management Component

• Storage Manager for SANs

• Microsoft.NET Framework 2.0

• Common Log File System

• Microsoft Services for NFS

• Subsystem for UNIX-based Application

• Windows SharePoint Services

NOTE: For more information on the R2 components, go to

www.microsoft.com/WindowsServer2003/R2/default.mspx.

NOTE: If you are installing the Hardware Management component on a recently released Dell system, a message

appears containing information about third-party IPMI drivers. For more information on this message, see the document Important Information for Windows Server 2003.

Installing Specific R2 Components on Your System (optional)

Perform the steps below to install a specific R2 component on your system:

Log on as an administrator and click

or Remove Programs

Click on

Add/Remove Windows Components

Start→Settings→Control Panel

, and then double-click on

The Windows Components Wizard window appears.

Deployment Guide 9

Add

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.com/en- us/library/ms143506.aspx.

Configuring Networking for SQL Server 2005

This section provides information about configuring the network interface for connecting to the public network.

NOTE: The node requires a unique public IP address. The public IP address should be registered with DNS.

If a DNS server is not available, then the IP address must be registered in the hosts file in the node.

For a single server running SQL Server 2005, it is recommended that at least two network interfaces are used, and that the interfaces be teamed to provide additional redundancy for the database server.

For a SQL Server 2005 cluster, each node must contain at least two network interfaces: one for the cluster interconnect (heartbeat), and one for client connections (public). It is recommended that a third interface be added, which allows network interface teaming to be employed on the public network. NIC Teaming is not supported on the heartbeat network.

Configuring NIC Teaming for Your Public Network Adapters

The network teaming drivers and utilities must be installed before completing these steps. These items can be installed from the Dell Database Resource CD.

NOTE: TCP Offload Engine (TOE) functionality for TOE-capable NICs is not supported in this solution.

Identify the two network adapters that will be used for NIC teaming.

Connect an Ethernet cable from each selected network adapter to the public network switch.

If you have Broadcom NICs, go to step 4. If you have Intel NICs on node 1, configure NIC teaming by performing the following steps:

Right-click

In the

Expand

Right-click the Intel NIC, which is identified for NIC teaming and click

The

Click on the

Select

My Computer

and select

Computer Management

Network adapters

Properties

window appears.

Teaming

tab.

Team with other Adapters

Manage

window, click

and click

New Team

Device Manager

10 Deployment Guide

Properties

Specify a name (for example,

In the

Select the Adapters to include in this Team

you identified for NIC teaming and click

From the

Click

The

Click OK.

Click OK to close the

If you have Broadcom NICs, configure NIC teaming by performing the following steps.

On the Windows desktop, click

Select a team Mode

Finish

to complete the teaming.

Team: Properties

window displays.

Properties

Public

list, select

window.

Start

and select

) for the NIC team and click

box, select the remaining network adapters

Adaptive Load Balancing

Program→Broadcom→Broadcom Advanced

and click

Control Suite 2.

The

Broadcom Advanced Control Suite 2

Click

Tools

and select

The

Broadcom Teaming Wizard

Click

In the

Enter the name for the team

In the

Team type

In the

Available Adapter

add them to the

Click

Select

Do not Configure a Standby Member

When prompted to

In the

Creating/Modifying a VLAN

In the last window, select

Finish

In the

Broadcom Advanced Control Suite 2

Create a Team.

area, select

Smart Load Balancing (TM) and Failover (SLB)

s box, select the network adapters you identified for NIC teaming and

Team Members

Configure LiveLink

Preview changes in Broadcom Advanced Control Suite 2

window appears.

box.

window appears.

field, specify a name (for example,

and click

select No and click

window, select No and click

window, select

Apply

Public

A message appears cautioning that the network connection will be temporarily interrupted.

) and click

and click

Click

Yes

to proceed.

In the

IP Address Setting Reminder

In the

Broadcom Advanced Control Suite 2

window, click OK.

Deployment Guide 11

+ 25 hidden pages

Dell Microsoft SQL Server 2005 Owner's Manual

Specifications and Main Features

Frequently Asked Questions

User Manual

Contents

Software and Hardware Requirements

License Agreements

Important Documentation

Installing and Configuring the Operating System

Using the Dell™ PowerEdge™ Installation and Server Management Media to Perform a Clean Installation of the Operating System

Installing Microsoft Windows Server 2003 R2, Standard or Enterprise Edition with SP2 Using the Dell PowerEdge Installation and Server Management CD

Installing the R2 Components

Installing Internet Information Services (IIS) using the Windows Server 2003 SP2 CD

Configuring Networking for SQL Server 2005

Configuring NIC Teaming for Your Public Network Adapters