Moving a SQL 2008/Windows 2008 cluster to a new domain

  • Hello, I was wondering if anyone had any good pointers/articles on what to be aware of in terms of moving a SQL 2008/Windows 2008 cluster to a new domain?

    We have a new requirement for a particular sql cluster and related application servers to move from an existing domain to a new one (this is a suggestion that has come up in relation to PCI compliance). What are some issues to be aware of? I understand it's trickier than simply moving the instance to new machines.

    As far as I know, what would have to change, once the machines and new domains are configured, are:

    1. The service account(s) that the SQL cluster and non-clustered SQL components from OLDDOMAIN\SrvcAccount to NEWDOMAIN\SrvcAccount

    2. Add NEWDOMAIN\SrvcAccount as well as any additional application or user related domain accounts for NEWDOMAIN with appropriate permission.

    I found this article from Microsoft regarding SQL 2005 clusters and I'm wondering if it would work for 2008. http://support.microsoft.com/kb/915846/en-us

    Any other pointers in addition to 1 and 2 above would be appreciated. The article above seems to indicate that an uninstall of SQL may be required (at least for 2005, so hoping not necessary for SQL 2008).

    Thanks.

    Gaby
    ________________________________________________________________
    "In theory, theory and practice are the same. In practice, they are not."
    - Albert Einstein

  • personally I would deploy a new cluster into the new domain and migrate everything across.

    Is the new domain a child in the same forest as the current domain or are they totally separate?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Perry Whittle (11/27/2010)


    personally I would deploy a new cluster into the new domain and migrate everything across.

    Is the new domain a child in the same forest as the current domain or are they totally separate?

    As far as I know, completely separate.

    Gaby
    ________________________________________________________________
    "In theory, theory and practice are the same. In practice, they are not."
    - Albert Einstein

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply