Share via

user migration

Shelar, Rupesh 21 Reputation points
2021-02-01T03:07:47.37+00:00

Hi Expert,
I have windows user(domainx/userA) with domain x who has account to 7 sql server instance  and i want to migrate this windows new server client with domainy/userA. Do i have to migrate or copy or move access all from 7 servers to new server or any one of the server is sufficient examples
erver1,2,3,4,5,6,7- domainx/userANew
Server-domainy/userAor
how to take access all these seven server to new server?thanks,

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

Answer accepted by question author

Sean Gallardy - MSFT 1,901 Reputation points Microsoft Employee
2021-02-01T12:48:32.75+00:00

If you're creating a new login (such as a new login for an account in DomainY) then you'll need to create it as a login on all the SQL Servers you'd like that login to have access. There is nothing stopping you from scripting out the login and associated users, then changing the name for the DomainY items, but again it'll all need to be created. If SQL Server changes domains, then you'll need to have trust relationships in AD with those domains.

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.