I would appreciate some help please.
We are migrating a number of VMs with different versions of SQL instances from site A to site B, one instance per VM. Site A and B are in different domains. In Site B, the user ids are going to be different from what they are in Site A, so logins will need to change.
I have the following steps as my Pre & Post migration steps, could you kindly comment on them please, to see if I'm missing any thing? Please note also any question beside any of the steps listed below:
In the source instance (in Site A), enable mixed mode authentication and set 'sa' password, in case it is required for login in to SSMS in Site B.
Script out the existing SQL logins using Microsoft's script
In a text editor, edit the above scripted out create login script to replace the existing Site A login ids with the new Site B login ids, the hashed passwords in the script are retained.
Take a full backup of all the databases before the work begins
Stop all SQL Server services and change their start to manual
- The VM is cloned in Site A and migrated as-is to Site B by the server team.
- Question - Would you agree that the SQL services remain shut down while this server clone is taken?
Login to host server in Site B with a new AD account. New AD account must have local admin rights on the database host server
Ensure availability of correct service accounts to run the SQL services in Site B
In SSCM, start the SQL Server service in single user mode.
Start SSMS as an administrator and login with Windows authentication (new AD account with local admin rights). This should work but if not, use 'sa' account with the password set up above, login in with SQL Server authentication.
Run the edited create login script that was prepared in pre migration steps. It may be necessary to delete the old logins before running the edited script, to avoid it complaining about the SID already existing. Once the new logins have been tested successfully, log out of Management Studio.
In SSCM, stop services, change them to their original start settings i.e. Automatic etc and start them in muti-user mode
Once everything is running properly, disable 'sa' account and return authentication mode back to what it was in Site A.
Would you agree with these steps and are there any other steps I should be thinking of?