Share via

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

Mohd Arif 926 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.
13,361 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 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.
517 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,601 questions
Accepted answer
  1. Bjoern Peters 8,856 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

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Seeya Xi-MSFT 16,461 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