Connecting the SQL Servers

The following procedure describes how to connect and configure the network adapters on each server running SQL Server during deployment. Each server uses two network adapters: one connected to the Web cluster by a hub, the other connected to the other server running SQL Server by a crossover cable. Each server is also connected to a shared storage unit by a SCSI cable.

The SQL Server cluster requires two different cluster names and two different cluster IP addresses: one used by SQL Server, the other used by Cluster Service.

The following figure illustrates a sample network configuration for a SQL Server cluster.

To connect the servers running SQL Server

1. Make sure the shared storage unit is not powered on. It may be corrupted if it is connected to both servers while the power is on.
2. Connect the front-end network adapter to a hub that is connected to the firewall separating the Web tier from the database tier.
3. In the Internet Protocol (TCP/IP) Properties of this adapter, enter the IP address, Subnet Mask, and Default gateway.
4. Connect a crossover cable from the back-end network adapter to the back-end network adapter of the other server running SQL Server.
5. In the Internet Protocol (TCP/IP) Properties of this adapter, enter the IP address, Subnet Mask, and leave the Default gateway blank.
6. In Internet Protocol (TCP/IP) Properties, click Advanced.
7. In Advanced TCP/IP Settings, on the WINS tab, select Disable NetBIOS over TCP/IP.
8. Connect a SCSI cable to the shared storage unit.
9. Repeat steps 1-8 for the other server running SQL Server using different IP addresses.

Network configuration is complete on the SQL Server cluster. To install Cluster Service, see Configuring the Database Tier.

Copyright © 2005 Microsoft Corporation.
All rights reserved.