Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

migrate logins from one domain to another domain for the same SQL instance Expand / Collapse
Author
Message
Posted Tuesday, February 18, 2014 7:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 25, 2014 2:04 AM
Points: 4, Visits: 72
Hi All,

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.
Post #1542558
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse