How to Configure the Database Server Network Adapters
Each database server has one or two network adapters depending on the configuration of your network. The network settings that you use to configure the network adapters are in Configuring Network Settings for the Enterprise Deployment if you are building an enterprise deployment or Configuring Network Settings for the Base Deployment if you are building a base deployment.
Follow these steps to configure the network adapters and use the settings that were discussed earlier to configure your network adapters.
To configure the network adapter on the database servers for Windows Server 2003
On the desktop, right-click My Network Places, and then click Properties.
In the Network and Dial-up Connections window, right-click Local Area Connection, and then click Rename.
Type a name for the connection, for example, Domain Connection, that makes it easy to identify, and then press ENTER. This name will be referred to as <adapter name> from this point on.
Right-click <adapter name>, and then click Properties.
In the <adapter name>Properties dialog box, select the following components:
Install?
Component
No
Client for Microsoft Networks.
No
Network Load Balancing.
No
File and Printer Sharing for Microsoft Network.
Yes
Internet Protocol (TCP/IP).
Click Internet Protocol (TCP/IP), and then click Properties.
In the Internet Protocol (TCP/IP) Properties dialog box, on the General tab, select Use the following IP address, and do the following:
Use this
To do this
IP address
Type the IP address from the table of network settings.
Subnet mask
Type the subnet mask from the table of network settings.
Default gateway
Type the default gateway from the table of network settings.
For information about the specific IP address settings, see Configuring Network Settings for the Enterprise Deployment and Configuring Network Settings for the Base Deployment.
Click Advanced.
In the Advanced TCP/IP settings dialog box, on the WINS tab, select Disable NetBIOS over TCP/IP, and then click OK.
If a dialog box appears that states that the computer has an empty Primary WINS address, click Yes.
Type the following information so that this domain controller can resolve the primary domain controller:
Use this
To do this
Preferred DNS Server
Type the DNS server name provided by your network administrator.
Alternate DNS Server
Leave blank. If your deployment includes additional domain controllers, type the IP address of the additional domain controller. If you are configuring secondary, or additional, domain controllers, type the IP address of the primary domain controller.
Click OK.
Follow these steps for each network adapter.
To configure the network adapter on the Data Warehouse server for Windows Server 2008
On the desktop, right-click Network, and then click Properties.
In the Network and Sharing Center window, click Manage network connections.
Right-click Local Area Connection, and then click Rename.
Type a name for the connection, for example, Domain Connection, that makes it easy to identify, and then press ENTER. This name will be referred to as <adapter name> from this point on.
Right-click <adapter name>, and then click Properties.
In the <adapter name>Properties dialog box, select the following components:
Install?
Component
No
Client for Microsoft Networks
No
File and Printer Sharing for Microsoft Network.
Yes
Internet Protocol Version 4 (TCP/IPv4) and/or Internet Protocol Version 6 (TCP/IPv6)
If you are using Internet Protocol Version 4 (TCP/IPv4), perform steps 8 - 14, otherwise skip to step 15.
Click Internet Protocol Version 4 (TCP/IPv4), and then click Properties.
In the Internet Protocol Version 4 (TCP/IPv4) Properties dialog box, on the General tab, select Use the following IP address, and do the following:
Use this
To do this
IP address
Type the IP address from the table of network settings.
Subnet mask
Type the subnet mask from the table of network settings.
Default gateway
Type the default gateway from the table of network settings.
For information about the specific IP address settings, see Configuring Network Settings for the Enterprise Deployment.
Click Advanced.
In the Advanced TCP/IP settings dialog box, on the WINS tab, select Disable NetBIOS over TCP/IP, and then click OK.
If a dialog box appears that states that the computer has an empty Primary WINS address, click Yes.
Type the following information so that this domain controller can resolve the primary domain controller:
Use this
To do this
Preferred DNS Server
Type the DNS server name provided by your network administrator.
Alternate DNS Server
Leave blank. If your deployment includes additional domain controllers, type the IP address of the additional domain controller. If you are configuring secondary, or additional, domain controllers, type the IP address of the primary, or first domain controller.
In the Internet Protocol Version 4 (TCP/IPv4) Properties dialog box, click OK.
If you are using Internet Protocol Version 6 (TCP/IPv6), perform steps 16 - 20, otherwise skip to step 21.
Click Internet Protocol Version 6 (TCP/IPv6), and then click Properties.
In the Internet Protocol Version 6 (TCP/IPv6) dialog box, on the General tab, select Use the following IP address, and do the following:
Use this
To do this
IP address
Type the IP address from the table of network settings.
Subnet mask
Type the subnet mask from the table of network settings.
Default gateway
Type the default gateway from the table of network settings.
For information about the specific IP address settings, see Configuring Network Settings for the Enterprise Deployment.
Type the following information so that this domain controller can resolve the primary domain controller:
Use this
To do this
Preferred DNS Server
Type the DNS server name provided by your network administrator.
Alternate DNS Server
Leave blank. If your deployment includes additional domain controllers, type the IP address of the additional domain controller. If you are configuring secondary, or additional, domain controllers, type the IP address of the primary, or first domain controller.
In the Internet Protocol Version 6 (TCP/IPv6) Properties, click OK.
In the <adapter name>Properties dialog box, click OK.
Follow these steps for each network adapter.
See Also
Other Resources
Configuring Network Settings for the Base Deployment
Configuring Network Settings for the Enterprise Deployment