MS SQL Active/Passive Cluster and Active Directory Dependency
Posted on 2007-03-31
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?