Monday, February 20, 2012

Removing AD from server with SQL on it

I've got a situation where I need to move a server (server A) from the
domain (Domain A) that it is in (it is the only server in this domain)
into a different domain (Domain B). The curve ball is that SQL 2005
is set up on this server.
My question is: How 'broken' will SQL become if I uninstall AD/remove
it from the domain that it is in? I've done some VMWare testing and
forcing the demotion on the SQL box and bringing it into the other
domain isn't that big of a deal. The SQL data that resides on the
server A is just test data but is close to being a production server.
A carbon copy of all the users in Domain B have been recreated on
Server/Domain A.
Comments/suggestions?
Thanks in advance...
I don't think, it matters much as long as the server name is the same. The
SQL instances running on the server should be able to function without major
issues.
You have to make sure the service logins, if using domain accounts, should
be changed to match the accounts in the new domain. Any windows logins that
are mapped to any database users should be modified as well. If you have
special processes like backups to shared drives or log shipping, you'll have
to make sure the folder are shared with appropriate permissions for the new
accounts.
Anith

No comments:

Post a Comment