Impact on SQL 2005 server while migrating on new Domain
Hi, I want to migrate my existing domain to new domain. Many applications running on sql 2005 and cluster also. I want to know how to migrate sql server DB on new domain. what is the impact for sql migration ? Can I migrate all user and db on new domain ? If possible pl provide step-by-step guide.
This will be a big project for you so make sure you prepare. Depending on how you've set up your current environment you will need to recreate, at a minimum, the service accounts used and re-configure SQL Server. Then you need to recreate the groups/users you have used for accessing SQL Server in the new domain and add them after migration and re-establish your security as you'll most likely have many orphaned users afterwards. Microsoft's best practice for a cluster migration is to uninstall SQL Server and re-install after the migration.