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

Question

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.

Answer 1

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)

Answer 2

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.