Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 292
  • Last Modified:

Changing Domain Membership for SQL 2005 Cluster

I have an existing 2 node active/passive SQL 2005 Cluster.  I've been advised that the AD domain in which this cluster lives will be retired and a new prestine AD Forest/Domain is being deployed.  I need to make the cluster a member of that domain.  Do I have to completely break down the cluster, add the nodes to the new domain, then reinstall SQL in Failover cluster mode from scratch?  
0
adexchman
Asked:
adexchman
  • 2
1 Solution
 
Ted BouskillSenior Software DeveloperCommented:
Yes
0
 
65tdCommented:
Depends on how the DB's are permissioned, moving the boxes to the new domain and re-permissioning the rights the cluster service account uses.  The service account must have access to the quorum and data drives as well as the following rights:  http://support.microsoft.com/kb/269229

How is SQL running on the cluster (system account)?

Also see MS article http://support.microsoft.com/kb/269196
0
 
Ted BouskillSenior Software DeveloperCommented:
Trust me.  Our team tried this and it didn't work.  It's safer to rebuild it from scratch.
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now