Changing Domain Membership for SQL 2005 Cluster

Posted on 2007-07-24
Last Modified: 2008-02-01
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?  
Question by:adexchman
    LVL 51

    Expert Comment

    LVL 22

    Expert Comment

    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:

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

    Also see MS article
    LVL 51

    Accepted Solution

    Trust me.  Our team tried this and it didn't work.  It's safer to rebuild it from scratch.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
    In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now