Network Load Balance with three windows 2003 BOX ???

Hi Experts,

I have Windows Server 2003 Standard Edition running on two Dual Xeon Processors server (RAM 2GB)

I need to deploy a .net application running with Ms-SQL server on these two servers. And configure Network Load Balancing (NLB) on these two servers. (If needed I can add one more server to this setup)

This application is the corporate intranet and extranet which supported to media streaming too. This application shoulb be able to handle 500 to 1000 concurrent connections.

I’m clue less with the NLB , please explain me the best possible scenario to configure load balance on these servers.

Thanks !

Who is Participating?
Pete LongTechnical ConsultantCommented:
Start Cluster Administrator (Start, Programs, Administrative Tools, Cluster Administrator).
You'll see the Open Connection to Cluster dialog box. Under Action, select "Create new cluster" and click OK.
At the New Server Cluster Wizard welcome screen, click Next.
At the wizard page, enter the cluster's domain (the machine's local domain is selected by default) and a logical name for the cluster. The logical name isn't a virtual machine name but simply a name for the cluster. However, it must still be a valid NetBIOS name (15 characters maximum). Enter the required information and click Next.
You're then asked to select the first node that will be part of the new cluster. Select the current node (it's selected by default) and click Next.
Cluster Administrator will perform a check to ensure that the box that you selected as the first node is compatible with cluster functionality. After the check is finished, click Next.
At the next wizard page, you must provide an IP address that will be used to manage the entire cluster. Note that this is a new address, not the IP address of the new cluster node. Enter the address and click Next.
At the next wizard page, you need to enter information for the domain account under which the cluster service will run. The account must have local administrator privileges and will be granted additional rights after you've selected it. After you enter the account information, click Next.
Next, you'll see a summary of the information you've entered on the previous screens, which the Figure shows. Click Next to begin the cluster installation. Alternatively, if you want to view which drive has been selected as the quorum disk and, if necessary, change it to another disk or a majority node quorum, click Quorum. (By default, Cluster Administrator selects as the quorum drive the smallest NTFS drive greater than 50MB.)
After the cluster installation is finished, click Next, then click Finish.
Pete LongTechnical ConsultantCommented:
Stop! SQL is a statefull application - Microsoft recommends you DO NOT deploy it using an NLB cluster
You need an enterprise cluster (which wont run on 2003 Standard) and you will need some shared storage also
Pete LongTechnical ConsultantCommented:
NLB just puts one IP address on an application thats in multiple places (like a web server farm) so users get their requests distributed evenly between different cluster nodes.

SQL needs to write stuff to memory and transaction logs etc - so a user making changes on server A those logs wouldnt be commited to the Database on Server B etc etc
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

NetMaxtorAuthor Commented:
Thanks a lot Pete...

Do you want me to use Windows Enterprise ok I can do that.
Please be kind enough to explain me the best possible scenario for my requirement.
Pete LongTechnical ConsultantCommented:
Of course if NOTHING gets written to the database (the information is static) then NLB WOULD be an option
Pete LongTechnical ConsultantCommented:
In a true cluster you have multiple servers - running Server 2003 Enterprise
Thay all share some storage (usually a fiber channel SAN these days though ISCSI SAN is a cheaper option)
Then you configure a cluster from the CLuster manager in administrative tools
NetMaxtorAuthor Commented:
How would I plan the application installation?
Each server needs to install the application separately with MS-SQL data base or what ?

May be I don't have much idea about the cluster.. please explain me....
Pete LongTechnical ConsultantCommented:
You need to install SQL on ALL the servers
NetMaxtorAuthor Commented:
how these application share each other DB data.. replicate or something ?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.