Domain Name Change - SQL Server 2005 w/ SSRS and Mirroring.   We are considering doing a Domain change, which, being a DBA, I am not familiar with in terms of how this will affect our SQL installation

Posted on 2009-04-18
Last Modified: 2012-08-14

We are getting two new domain servers, and along with this change, our network admin is considering changing the domain name and the groups of the SQL users currently loggin in with Domain accounts.  I am very concerned about this since the information I have been finding seems to differ from something as simple as "Just need to change the service accounts and logins" to "May need to resinstall SQL".   I looked through some articles here but could not find a solid resource which shows the steps necessary in order to succesfully carry out a domain name change which considers SQL Server 2005, Mirroring, and SSRS (SSIS?).  If anyone can point me in the right direction I would appreciate it.  It seems that if not done correclty,  this can have unintended, far-reaching implications to the SQL Server environments.  There are probably resources already out there that explain this but I have not found a "good" one yet.  Any help or advice would be greatly appreciated.  Details are SQL 2005 SP2 GDR1, Windows Server 2003, Mirroring, SSRS, SSIS.   Thank you,  Keith
Question by:ecshadmin
    LVL 13

    Accepted Solution

    From what I can read into your question and what I know; the issue with SQL is if you change the name of the server; not the domain; but that's an easy fix anyway.

    I'm thinking that it would be a case of change the domain the server joins to in CompMgmt, reboot, fire up SQL and add the previous domain's users; but depending how quickly the migration is done; you may need to setup trusts between the two domains to allow users on the old domain access to your SQL Server...

    Do you have a virtual environment you could play about with and hone the migration plan?

    Author Comment


    We are going to test it out first on one of our development servers.  The problem is, we do not have a test environment that exactly parallels our production environment, so even if things go well in test, I'm concerned there may be other issues we will encounter when moving to production.  Maybe that is where we should focus first, trying to get dev to match production, although this is a large effort in our case.  I have found some other resources also, but still nothing solid.  I'll keep this post open for a while and see if any others respond.  I'll post more informatoin when we start making the changes in development and see the results.

    LVL 38

    Assisted Solution

    by:Jim P.
    The one thing I would definitely look at is to script out your SQL Users at the the server level (sp_help_revlogin in the first link below) and then use the DB Pub Wizard to script the database logins.

    Filter domain accounts at both levels and then drop and recreate them.

    How to transfer the logins and the passwords between instances of SQL Server 2005

    Microsoft SQL Server Database Publishing Wizard 1.1

    Author Comment

    Thank you, I've started looking into your suggestion.  Is DB Publishing wizard somehow different from the 'Generate Scripts" task?   The information you provided is much appreciated...
    LVL 38

    Assisted Solution

    by:Jim P.
    The generate scripts is more for one database. The pub wizard should be able to do it for all databases at the same time. Plus ownership rights and roles, etc.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Introduction: Sometimes when I receive a call from my users to solve their problems it is very difficult for me to found their computer IP address. Even finding their computer Host to provide remote support can be a problem.  So I resorted to Goo…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now