Results 1 to 2 of 2
  1. #1
    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?

  2. #2
    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."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts