user migration sql server

Shelar, Rupesh 21 Reputation points
2021-02-01T03:11:36.843+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 example

server1,2,3,4,5,6,7- domainx/userA

New Server-domainy/userAor how to take access all these seven server to new server?thanks,

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
532 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 22,201 Reputation points Microsoft Vendor
    2021-02-02T07:10:29.037+00:00

    Hi @Shelar, Rupesh ,

    Migrate SQL servers to new domain. You need to create new logins (such as a new login for an account in DomainY) on all the seven SQL Servers. You can script out the logins and associated users on the old servers then change the login name from domainx/userA to domainy/userA, then run the scripts on new servers to create the new logins.

    If the response is helpful, please click "Accept Answer", thank you.

    0 comments

Your answer

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