SQL Server Domain Migration

• inderrathore

  SSC Veteran

  Points: 212

  More actions

  March 7, 2010 at 11:09 pm

  #217641

  Hi Champs,

  I have requirement to Migrate SQL server 2005 from one doamin/forest to another Domain/forest.

  I have few applications and some applications use SQL authentication and some uses AD authentication. I am pretty comfortable about applications those are using SQL authentication is there will not be issue if i move Application anywhere to domain/forest.

  My concern was on SQL Databases and application those are tied up AD authentication. Will you experts suggest me what would be approach and steps tp move such types of SQL setups to different domain/forest where users getting authetincated Via Active directory.

  Thanks in Advance 🙂

  Regards

  Inder.

• FabricioLimaDBA

  Mr or Mrs. 500

  Points: 507

  More actions

  March 8, 2010 at 6:23 pm

  #1130368

  For each Windows Autentication Login you need to create another login in the new DOMAIN.

  You need to change the account that start the SQL Server services if that use a Domain account.

  I change my DOMAIN a few month ago. Try to translate this post:

  http://www.mcdbabrasil.com.br/modules.php?name=Forums&file=viewtopic&t=3595

  I'm from Brazil. I have a basic English. I hope help you.

  Fabrício França Lima
  MCITP – Database Administrator
  https://www.fabriciolima.net/Blog