Post reply

Domain Migration

  • December 7, 2006 at 4:06 am

    #67820

    Hello,

    does somebody knows the steps to migrate sqlserver 2000 from a domain to another one?

  • December 7, 2006 at 4:13 am

    #676539

    are your databases using SQl or windows authentication ?

    how many accounts are in there ?

  • December 7, 2006 at 4:17 am

    #676540

    Both, sql and windows authentication. Waht about th system accounts?

  • December 7, 2006 at 4:26 am

    #676541

    you could change them to localsystem while you drop the server back to a workgroup , then onto the new domain - have you created new service accoutns in the new domain ?

     

    from what I can see it only gets complex if you have a cluster.

  • December 7, 2006 at 4:32 am

    #676543

    i did not yet created the new services accounts in the new domains. That s why i ask for the steps to perform this.

  • December 7, 2006 at 12:31 pm

    #676713

    You need to change your service account if you are using the domain account other than I don't think you need to anything...

    I think your server is not in cluster... then nothing to worry...

     

     

    MohammedU
    Microsoft SQL Server MVP

  • December 7, 2006 at 2:37 pm

    #676747

    First question... is there a trust between the two domains? Second questions... is this a complete migration (to include all user accounts, etc.)?

     

    K. Brian Kelley
    @kbriankelley

  • December 9, 2006 at 12:05 pm

    #677122

    I agree to brian kelly about having cross domain TRUST & that will save time.

  • December 9, 2006 at 1:04 pm

    #677127

    Cross domain trust is based on company rules and decision...

    Yes it good to have but it is not required as long as you have the option to move the backups for restore.

     

    MohammedU
    Microsoft SQL Server MVP

  • December 11, 2006 at 12:38 am

    #677147

    yes the domains are trudted and all account have to migrate. But i dont know what will happen with all the DTS, moving, copying files from servers to servers....

  • December 11, 2006 at 7:20 am

    #677175

    Moving SQL Server is fairly simple... if it's not a cluster. You get the service accounts in the new domain, give them the appropriate permissions (changing service accounts via Enterprise Manager is the best way to guarantee this), and change the service accounts out and the SQL Servers are now running under user accounts in the new domain. The caveat here is if the SQL Server service account (and SQL Server Agent service account) access things outside of SQL Server, such as mail, file shares, etc. In that case, you'll need to make sure the appropriate permissions are granted BEFORE making the change. That also means you'll need to map out where all your SQL Server and Agent service accounts touch.

    Migrating users/groups is more difficult. Hopefully your domain migration team has a mapping from the old groups/users to the new groups/users. You'll need that. And then you'll have to do the permission setup to match new and old. If you've already got pre-created database roles, things are a whole lot easier.

    Clusters, as I said, are a whole different story. But all in all, with the proper detailed planning, this isn't that difficult to implement. We found our biggest challenge was collecting the information of where all SQL Server touched and figuring out how the users and groups mapped. Once we did that migrating our SQL Servers was very little trouble at all.

     

    K. Brian Kelley
    @kbriankelley

  • December 12, 2006 at 3:29 am

    #677417

    Brian,

    thank you for the answer. Our SQL server is not in a cluster. The first step wil be to migrate the dev server and see what will happen.

Viewing 12 posts - 1 through 11 (of 11 total)

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