Post reply

changing Domain

  • January 13, 2004 at 2:46 pm

    #108649

    I need to change the domain under which production SQL server is running. What will be the way to do this with the minimum downtime and what complications I could expect?

    Thanks,

    MJ

  • January 13, 2004 at 2:59 pm

    #489862

    Here is the link to change domain for clustered SQL Server instance.

    http://support.microsoft.com/default.aspx?scid=kb;en-us;319016&Product=sql2k

    For non-clustered installation, You need to change the service account if you run SQL Server servcies with domain account. I would install a test instance in current domain and move it to new domain before making changes to production SQL Server.

     

  • January 13, 2004 at 3:04 pm

    #489865

    Don't forget the logins that are granted to access SQL Server from old domain.

  • January 13, 2004 at 3:10 pm

    #489867

    I was ready to script all logins and just to run them against the new domain. Could you recommend something easier?

    Thanks,

    MJ

Viewing 4 posts - 1 through 3 (of 3 total)

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