SQL Server 2005 migration to a new domain
Posted on 2012-09-15
Our entire office is moving to a new building. This new building will merge two companies, each currently with their own AD domain. In order to start fresh, we are implementing a new domain, with new services (Exchange 2010, BES 5.0, Domain Services, etc.). We currently have a SQL Server 2005 VM that hosts several databases. We want to migrate this server that hosts SQL Server to the new domain and we're looking for the easiest steps to get this done. This is a stand alone SQL Server. The name won't change, we just want to join it to a new domain. The 2005 server is currently hosted on a Windows 2003 server.
What are the easiest steps we need to do to get this done?
The SQL server is currently a VM, can we make changes and if it doesn't work, can we restore a backup of the VM?
To note, we will be implementing a new SQL Server 2008 Standard R2 instance and we may migrate the data from the 2005 server to this new 2008 server, but we don't want to do that now. The SQL Server 2008 instance will be on a Windows 2008 Enterprise R2 VM. Knowing all of this, would you recommend migrating the data to the new SQL Server 2008 server instead?