Microsoft KB Archive/268317

From BetaArchive Wiki
Knowledge Base


How to Configure Network Load Balancing Web Services with Back-End SQL Server

Article ID: 268317

Article Last Modified on 2/28/2007



APPLIES TO

  • Microsoft Windows 2000 Advanced Server



This article was previously published under Q268317

SUMMARY

This article describes how to configure Network Load Balancing Web services with a back-end SQL server.

Network Load Balancing distributes incoming Transmission Control Protocol/Internet Protocol (TCP/IP) traffic between multiple servers. When you use Network Load Balancing, your clustered programs, especially Web-server programs, can handle more traffic and provide faster response times.

MORE INFORMATION

Network Load Balancing can provide fault tolerance and scalable Web services that use a back-end SQL server. The preferred configuration for this scenario is:

  • Two network adapters for each host are required: one network adapter for cluster traffic and heartbeats, the other network adapter for replication and back-end processes.
  • Locate all cluster hosts on a single broadcast subnet.
  • For additional security, assign a private Internet Protocol (IP) address to the back-end network adapter.
  • Use an Lmhosts hosts file to ensure that the Hosts in the cluster use the back-end network adapter and private address to communicate with each other.

For additional information about configuring load balancing settings ingeneral, click the article number below to view the article in the Microsoft Knowledge Base:

198496 How to Configure WLBS Port Rules


For additional information about load balancing settings for specificconfigurations, click the article numbers below to view the articles in the Microsoft Knowledge Base:

219285 Load Balancing FTP with WLBS


232141 Load Balancing Telnet with WLBS


219277 Load Balancing HTTP with WLBS


203597 Load Balancing PPTP with WLBS


Keywords: kbhowto kbnetwork kbnlb KB268317