Hi There
I am trying to find resources of comsiderations / steps to take when changing a sql server instatnce's domain, the name will be the same but it is being moved to a new domain.
One thing i have realised is that replciation must be completely removed and reconfigured , since the sunscriber / distributor are all going to the new domain.
replcation still obviously referencing the old domain.
But what are all the other things that may be affected. A link to an article with details of how to move a sql server 2005 instance to a new domain would be great i just cant find one.
Thanx
If you're using windows authentication, any domain users or groups that have access would have to be changed.|||The first question that I have for you is: Are the new domain and the old domain trusted to each other?
If they are, then things will be a bit easier.
If they are not then you will need to make sure that you have the sa password, because none of your domain accounts will work until after you give them admin rights to the SQL Server. You will also need to give the services the new domain account and password that they will be running under, as well as give that account the needed rights in the database. All of your domain users will need to have there new accounts granted rights to the SQL Server again.
|||Cool Thanx
No comments:
Post a Comment