February 1, 2021 at 3:04 am
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/userA
or how to take access all these seven server to new server?
thanks,
February 1, 2021 at 11:06 am
Can you elaborate a bit?
There is a windows client domainx\userA on client Z on domainx
That has acces to server 1,2,3,4,5,6,7
Question:
If i move the user from client Z to client W, do I need to move server 1,2,3,4,5,6,7 ?: Normally not, the user is still in the same domain. Servernames aren't changed so there wouldn't be a lot of configuration changes. The login domainx\userA still works on 1,2,3,4,5,6,7
February 1, 2021 at 3:09 pm
Hi Expert,
Is AD account changes or Sql server changes
February 2, 2021 at 9:31 am
Test before you try this
Now it is more clear (misread domainy). You want to change the domain of the client and make sure the acces to the original sql servers (domainx) still works.
If there is an AD-trust between domainx and domainy, the client can still authenticate to domainx ( domain sql server). If you used windows groups for rights-management, you'll will only have to add domainy\user to the original windows group (if domainx continues to exists). Without groups you might get by with renaming the logins on the several sql server instances. Safer option: create new logins
With no AD-trust, you'll have to resetup all your sql server to the new domainy or work with sql server authentication. In both cases you'll have new users
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply