What will be impact if I rejoin a windows MS SQL DB server in the domain

Mohd Arif 921 Reputation points

There is a trust relation ship issue between my MS SQL DB (Windows) machine and AD. I need to rejoin it in domain. If I remove it from domain and rejoin it, will there be any serious impact? I will also be doing similar activity to the application which is using this DB.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,692 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,452 questions
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.
494 questions
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,552 questions
{count} votes

Accepted answer
  1. Bjoern Peters 8,781 Reputation points

    Normally I won't expect any problems as it will be the same domain.
    All user-guids stay the same and a connection between domain-users on the SQL instance can be paired again.

    Due to the login process onto a SQL Server, there is no key or a checksum changing, so just remove the server from the domain and rejoin.

    Maybe you should check if the SPNs are still exist => better you have a list of al required (or actually created SPNs) for that SQL Server that you'll be able to re-create them.


    (If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Seeya Xi-MSFT 16,436 Reputation points

    Hi @Mohd Arif ,

    Welcome to Microsoft Q&A!
    Please refer to this article which contains more details:

    Best regards,

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    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 No comments