We are migrating sql server instances from one domain to a different domain. New AD accounts/groups will be used in the new domain so SQL logins and database users in the source SQL instances will be unusable in the target instances.
Migration is by taking a snapshot backup of the host server and restoring to the target environment, which means the SQL instances have come across with the server images.
Having logged in to the migrated host server with new credentials, we now need to login to the SQL server to configure the security with new AD accounts.
Is there any other way of login in to the SQL server apart from doing so as sa with SQL authentication?
I am unable to use SSMS even in single user mode, as there is no valid AD login that can be used.
Does anyone have any other ideas please? Thank you so much.