Moving SQL and File Server from One Domain to Another

In my environment there is a internal network and DMZ. The DMZ has a small isolated domain in place and setup long before I started here. Anyway this domain is slowly going to be going away and I would like to move the SQL and filer server behind out firewall.

The internal and external domain are separate and no trust exist nor do I want to create one.  I going to do the following.

1) Document all services in use on the SQL server
2) Document all folder permissions on the file server using icacls
3) discjoing the servers from the domain and add it to the internal network.
4) setup the new service account for sql to use
5) Do the same process with the file server but use icacis to popules the security permissions with user from the internal domain.

This is a high level overview but is it valid?
LVL 20
compdigit44Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mohammed KhawajaManager - Infrastructure:  Information TechnologyCommented:
It is valid, however, ensure to have local\administrators with sysadmin privileges on the SQL server.  On the file server, ensure to have a local account added to all the shares and NTFS rights to ensure you have access.  After the move, ensure to add users/groups from the new domain and remove the old domain accounts.

Prior to doing any of these, ensure to at least create a system state backup (preferably full server backup of each server) so that you could revert back to original configuration if needed.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
compdigit44Author Commented:
Thank you for confirming my base game plan :-)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Active Directory

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.