Thread: Migration to new Domain
07-25-12, 18:46 #1Registered User
- Join Date
- Jul 2012
Unanswered: Migration to new Domain
We have a network setup with two domain controllers, DC1 and DC2, working independently from eachother along with a DBserver1 that runs a BCM database and is a member of DC1. For certain reasons we would like to demote the DBserver1 and join it on the domain of DC2. What are the steps required in order to properly move a BCM Database running on SQL2005 to a new domain, where the security data lies in the active directory of DC1?
07-30-12, 12:05 #2Registered User
- Join Date
- Jul 2003
- San Antonio, TX
Not sure what you mean by "security data lies in AD of DC1", but you can change domain membership for a SQL Server. First, set SQL and Agent services to run under local box accounts. Then change the membership of the box, and lastly set the services to run under DC2 domain accounts. Check the database and job ownerships before you do all that, to make sure none of them are owned by accounts in DC1 domain."The data in a record depends on the Key to the record, the Whole Key, and
nothing but the Key, so help me Codd."