Share via

Need support to join SQL 2017 cluster to new Domain

chinda sam 1 Reputation point
2021-08-14T02:41:00.26+00:00

Hello all,
We got one requirement from the customer.
They will implement a new Domain controller and a new forest.
Existing information: OLD-AD01 (OS Win. 2003)
OLD-SQL1 (OS Win. 2016)
OLD-SQL2 (OS Win. 2016)
SAN-Storage

New Domain controller 2019.
NEW-DC01

We want to join the existing SQL cluster to a new domain.

Could you advise the procedure?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,361 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AmeliaGu-MSFT 13,971 Reputation points Microsoft Vendor
    2021-08-16T05:31:43.857+00:00

    Hi chindasam-5378,

    Welcome to Microsoft Q&A.
    SQL Server cluster is based on Windows server cluster. In Windows Server 2016 and earlier, the Cluster service didn't have the capability of moving from one domain to another. This was due to the increased dependence on Active Directory Domain Services and the virtual names created.
    There are two options to do such a move. The first option involves destroying the cluster and rebuilding it in the new domain. The second option is less destructive but requires additional hardware as a new cluster would need to be built in the new domain. Once the cluster is in the new domain, run the Cluster Migration Wizard to migrate the resources.
    Please refer to this doc for more information.

    Best Regards,
    Amelia

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments