MS SQL Active/Passive Cluster and Active Directory Dependency

I am in the process of developing a proposal for an Active/Passive SQL Cluster.  The plan will be to run on Windows 2003 Enterprise with SQL 2000 (customer requires 2000 not 2005).

The front end servers that will be using the cluster is a web application that collects data, and another component of the app presents results from queries on the data.  The authentication model is forms based and does not need to use LDAP/AD.

What I am not sure about is wether a MS SQL Active/Passive cluster will require an AD server.  Can the local user accounts be used or do the servers in the cluster have to participate in Active Directory?
BladesAwayAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rboyd56Commented:
The cluster servers have to be member servers in a domain. This is from this artilcle:

http://support.microsoft.com/kb/281662

To have Windows Clustering function properly (where the Cluster service starts on each node) the node that forms the cluster must be able to validate the Cluster service domain account, which is the account that you configure during the Windows Clustering installation. To accomplish this, each node must be able to establish a secure channel with a domain controller to validate this account. If the node cannot validate the account, the Cluster service does not start. This is also true for other clustered programs that must have account validation for services to start, such as Microsoft SQL Server and Microsoft Exchange.

This indicates that the nodes of the cluster must be members of a domain. Also the SQL Server service account has to be a domain account as well.
0
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
<<What I am not sure about is wether a MS SQL Active/Passive cluster will require an AD server.  Can the local user accounts be used or do the servers in the cluster have to participate in Active Directory?>>
In short, no.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rboyd56Commented:
<<What I am not sure about is wether a MS SQL Active/Passive cluster will require an AD server.  Can the local user accounts be used or do the servers in the cluster have to participate in Active Directory?>>
If by participate in Active Directory,  you mean must the servers do the servers have to be members of a domain, then the answer is yes they do.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Server Software

From novice to tech pro — start learning today.

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.