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

Mohd Arif 921 Reputation points
2022-08-18T07:21:50.043+00:00

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
Transact-SQL
Transact-SQL
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
    2022-08-18T11:26:11.797+00:00

    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.

    https://www.mssqltips.com/sqlservertip/4875/script-to-check-and-auto-generate-spns-for-sql-server/

    (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
    2022-08-19T07:47:42.007+00:00

    Hi @Mohd Arif ,

    Welcome to Microsoft Q&A!
    Please refer to this article which contains more details:
    https://help.deepsecurity.trendmicro.com/12_0/on-premise/kerberos-mssql.html

    Best regards,
    Seeya


    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