SQL Server Domain Migration

  • 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.

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply