Avatar of Phase2
Phase2
Flag for United States of America asked on

How to cluster SQL 2008 with NLB

Hi guys!
I am trying to set up a SQL Server 2008 Cluster that uses NLB.

I will have 2 Windows Server 2008 Enterprise boxes that will run SQL 2008 enterprise.

I want to cluster these two servers then use NLB to manage traffic.

1. What are my options here?
2. Should I use windows clustering, SQL 2008 clustering, or both?
3. How can I use NLB on a cluster? Should I use ISA to load balance or should I use Windows NLB?

Eventually I will be running a project server on the front end.

Any resources, tutorials, or instructions on this would be very helpful. This is my first SQL clustering project so I'm a bit green.

Thank you for your time and help!


Microsoft SQL Server 2008Windows Server 2008Microsoft SQL Server 2005

Avatar of undefined
Last Comment
Phase2

8/22/2022 - Mon
RdWinXpert

Hi

This document will help.

download.microsoft.com/.../SQLServer2008FailoverCluster.docx
Phase2

ASKER
Forgot to mention that this will be on a SAN which i believe windows clustering is compatible with.
Phase2

ASKER
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
ASKER CERTIFIED SOLUTION
Phase2

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.