sql server failover clustering move domain

hotmail.com bangu00 161 Reputation points


i have sql servers with failover cluster on win 2016.
and nodes joined to ad(a.com).
i'm planning to move the nodes to new ad(b.com).
is there easy way?
i think follow steps.

  1. backup database and shutdown db
  2. destroy cluster
  3. rejoin new domain
  4. create cluster
  5. create role with sql server and msdtc
  6. service start
  7. restore database
  8. test failover
    could you please is it correct? anybody confirm me.

Have a nice day. in korea, groomy today. :-(

Azure Active Directory Domain Services
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
394 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
801 questions
{count} votes

2 answers

Sort by: Most helpful
  1. CathyJi-MSFT 20,976 Reputation points Microsoft Vendor

    Hi @hotmail.com bangu00 ,

    Suggest you to read MS blog Migrating SQL Server to New domain and the third blog SQL SERVER – How to Move SQL Server Cluster to Different Domain to get detail information.

    Hope these blogs could help you.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    1 person found this answer helpful.
    0 comments No comments

  2. hotmail.com bangu00 161 Reputation points


    I'm sorry for the late reply.
    Cathyji-msft's reply didn't really help me much.
    I don't think the link you gave me is the answer to my procedure.

    thank you.

    0 comments No comments