My project requirement is to migrate logins from one domain to another domain and for the same instance of SQL server(2k-2k, 2k5 -2k5 and 2k8-2k8) i.e without changing the host or migration. They are planning to move their existing SQL instances from their old domain (ABC) to a new domain (XYZ) and our job is to set up the new XYZ trusted users in each of the SQL server instances.
The servers are going to new domain and we required to create the new logins and users with same server level roles and database level roles and permissions as of the existing logins and databse users accounts in the old domain.
We are not allowed to disable or alter any existing logins and database user accounts while creating the new accounts with the new domain.
This is required for windows level account only.
Please share any scripts which can help me here to perform this Security migration for windows accounts.
Thanks for the help in advance.