Migration of SQL SERVER from One Domain to Another Domain

Question

Can anyone please point me to some reference in regarding migration of a SQL Server 2008 from one domain to another?

Many thanks in advance.

Rohit

Answer 1

Hi

Below is the link for you to go through.

The SQL Server 2008 is highly outdated and unsupported hence its a high risk. For safety, I would suggest you to upgrade your sql server to a higher and latest version before you perform the activity.

https://social.technet.microsoft.com/wiki/contents/articles/24960.migrating-sql-server-to-new-domain.aspx

Also read this to know what might go wrong in worst case...

https://dba.stackexchange.com/questions/301440/what-elements-of-sql-server-are-impacted-due-to-removal-of-domain-ad

Please Upvote and Accept as answer if the reply was helpful.

Answer 2

Hi @Rohit Kulkarni ,

You can migrate SQL Server instance to new domain using 'Active Directory Migration Tool', you have also to change your job owners, proxy accounts, and service accounts to the new domain as well. If you continue to use accounts from the old domain make sure the trust works and do not forget to rename the integrated login names when the windows domain name has been changed

Referring to:
https://learn.microsoft.com/zh-cn/archive/blogs/mdegre/can-i-move-sql-server-to-another-domain

If it is a cluster then this is not supported, Domain migration for SQL Server 2008 failover cluster instance is not supported, you must reinstall the SQL Server failover instance

Referring to :https://social.msdn.microsoft.com/Forums/sqlserver/en-US/cefc4470-081e-418d-8e24-eb8297456734/moving-sql-server-2008-single-instance-to-new-domain?forum=sqldatabaseengine

At the same time, you can consider upgrade your SQL Server, SQL Server 2008 is too old and the latest verison is 2019

---

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.