Export (0) Print
Expand All
4 out of 8 rated this helpful - Rate this topic

Installing ADMT in the Target Domain

Updated: October 7, 2011

Applies To: Windows Server 2008, Windows Server 2008 R2

Applies to: Active Directory Migration Tool 3.1 (ADMT 3.1) and ADMT 3.2

Use either of the following guidelines to install the Active Directory Migration Tool (ADMT), depending on which version you are installing. ADMT version 3.1 provides an option to install a preconfigured Microsoft SQL Server® Express database instance. ADMT version 3.2 requires a SQL Server database instance to be previously installed. The remaining guidelines for detaching, reconfiguring, and removing a database file apply to either version of ADMT.

This section covers the following issues for installing ADMT v3.1

When you install the Active Directory Migration Tool version 3.1 (ADMT v3.1), it also installs SQL Server 2005 Express Edition by default to use as its data store. As an option, you can configure ADMT v3.1 to use a SQL Server 2000 with a Service Pack 4 (SP4) Standard or Enterprise Edition database or SQL Server 2005 Standard or Enterprise Edition installation that you have previously created.

Before you install ADMT v3.1, complete the following prerequisites:

  • Install Windows Server 2008.

  • Remove all previous versions of ADMT by using Add or Remove Programs from Control Panel. If you attempt to install ADMT v3.1 on a server that has a previous version of ADMT installed, you receive an error, and the installation does not proceed. If necessary, you can import the database from the previous version of ADMT (such as ADMT v2.0 or ADMT v3.0) into ADMT v3.1 during the installation.

  • If you do not plan to use the default local database installation, ensure that another SQL Server 2000 or SQL Server 2005 database installation is configured with an ADMT instance. For more information about creating an ADMT instance on a SQL Server database, see Installing ADMT Using a Preconfigured SQL Database.

You can use the default database store based on SQL Server 2005 Express Edition or a preconfigured SQL database to install ADMT. The most common and recommended installation method is to use the default database store, which the Active Directory Migration Tool Installation Wizard configures automatically.

  • Depending on your environment, download ADMT v3.1 (http://go.microsoft.com/fwlink/?LinkId=121732) or ADMT v3.2 (http://go.microsoft.com/fwlink/?LinkId=186197). For more information about which version of ADMT to use, see Active Directory Migration Tool versions and supported environments. From the download location, double-click admtsetup.exe, which opens the installation wizard.

     

    Wizard Page Action

    Welcome to the Active Directory Migration Tool Installation

    Click Next.

    Configuring Components

    The ADMT database instance (MS_ADMT) is created on the local computer.

    Although SQL Server 2005 Express Edition is installed locally by default whether ADMT uses it or not, ADMT disables SQL Server 2005 Express Edition if you specify another database instance on the next wizard page.

    Database Selection

    Specify the database instance you want to connect to. The recommended selection is Use Microsoft SQL Server Express Edition, which configures ADMT v3.1 to use the locally installed database instance.

    If you are using multiple ADMT v3.1 consoles or have a dedicated database server where you want to centralize your ADMT database, select the Use an existing Microsoft SQL Server option. Specify the server to connect to in the form of Server\Instance.

    You should configure the SQL Server database instance before you select this option. Although the ADMT v3.1 installation proceeds if the database cannot be contacted, you cannot use ADMT to migrate accounts or resources until the database instance is created and available.

    Active Directory Migration Tool v3 Database Import

    Although you cannot upgrade an ADMT v3.0 installation to ADMT v3.1, you can import data to an ADMT v3.1 database from an ADMT v3.0 database.

    If you do not want to import data from an ADMT v3.0 database, select No, do not import data from an existing database (Default).

    If you want to import data from ADMT v3.0 into the new ADMT v3.1 database, select Yes, please import data from an ADMT v3 database.

    If you choose to import data, specify the path to the ADMT v3.0 database file.

    Active Directory Migration Tool v2 Database Import

    Although you cannot upgrade an ADMT v2.0 installation to ADMT v3.1, you can import data to an ADMT v3.1 database from an ADMT v2.0 database.

    If you do not want to import data from an ADMT v2.0 database, select No, do not import data from an ADMT v2 database.

    If you want to import data from ADMT v2.0 into the new ADMT v3.1 database, select Yes, please import data from an ADMT v2 database.

    If you choose to import data, specify the path to the ADMT v2.0 database file.

    The ADMT v2.0 database has the filename protar.mdb, and should be located in the directory formerly used for your ADMT v2.0 installation.

    Summary

    This page summarizes the options you selected. To complete the ADMT v3.1 installation, click Finish.

ADMT v3.2 requires a preconfigured instance of SQL Server for its underlying data store. You should use SQL Server Express and install ADMT v3.2 on a member server. When you use one of the following versions of SQL Server Express, ADMT installation enforces the following service pack requirements:

  • SQL Server 2005 Express must be installed with Service Pack 3 (SP3) or later.

  • SQL Server 2008 Express must be installed with Service Pack 1 (SP1) or later.

    noteNote
    If you use SQL Server Express, the ADMT console must be installed and run locally on the server that hosts the SQL Server Express database instance.

As an option, you can use full versions of SQL Server 2005 or SQL Server 2008. In this case, you can install and run the ADMT console on a remote computer, and you can run multiple ADMT consoles on different remote computers. If you use a full version of SQL Server, ADMT installation does not enforce any service pack requirements.

The rest of this section covers the following installation issues:

Before you install ADMT v3.2, complete the following prerequisite tasks:

  • In Control Panel, use Add or Remove Programs to remove all versions of ADMT earlier than ADMT v3.2.

    Although ADMT v3.2 does not support an upgrade from a previous version of ADMT, you can reuse an existing database from a previous ADMT installation, unless it is a database from ADMT v2 or ADMT v1. For more information, see Reuse an existing ADMT database from a previous installation.

  • Install or upgrade a server computer (preferably a member server) in either your source or target domain environment as necessary to run Windows Server 2008 R2. If you do not install ADMT on a member server, use a full version of SQL server when you install ADMT v3.2 on a domain controller.

    Although you can use ADMT v3.2 to migrate accounts and resources from Active Directory environments that have a domain functional level of Windows Server 2003 or later, you can install ADMT v3.2 only on a server running Windows Server 2008 R2.

    In addition to running Windows Server 2008 R2, the server computer that you use to install ADMT v3.2 must not be installed under the Server Core installation option or be running as a read-only domain controller (RODC).

  • Configure a SQL Server database installation with an ADMT instance. You can either download and install SQL Server Express locally or create a database instance for ADMT from an existing SQL Server database.

    For more information about installing SQL Server Express, see Install ADMT v3.2. For more information about creating an ADMT instance on an existing SQL Server database, see Install ADMT by Reconfiguring a Database Installation with Admtdb.exe.

Download SQL Server 2005 Express (http://go.microsoft.com/fwlink/?LinkId=181159), or create a new database instance on an existing SQL Server installation to use with ADMT v3.2. During the SQL Server installation, select Windows Authentication Mode. After you install SQL Server, use the following procedure to install ADMT v3.2.

Membership in Administrators, or equivalent, is the minimum required to complete this procedure. Review details about using the appropriate accounts and group memberships at Local and Domain Default Groups (http://go.microsoft.com/fwlink/?LinkId=83477).

  1. In the ADMT download package, double-click admtsetup32.exe.

  2. On the Welcome page, ensure that the recommendations are completed, and then click Next.

  3. On the License Agreement page, click I Agree, and then click Next.

  4. On the Database Selection page, type the server\instance.

    The requirement to type the server name also applies to a local database instance. You can type a dot (“.”) to indicate the local server. By default, the SQL Server Express instance is named SQLEXPRESS.

    For example, to use a default SQL Server Express instance on the local server, type .\SQLEXPRESS.

  5. If you chose a SQL Express installation and a database file ADMT.mdf is not in the default data location %windir%\ADMT\Data, the Database Import page appears. Otherwise, ADMT Setup automatically attaches to that database file, and the Summary page appears.

    On the Database Import page, if you do not need to import data, click No, do not import data from an existing database (Default). If you need to import data from a previous ADMT installation, click Yes, import data from an existing ADMT v3.0 or ADMT v3.1 database, and then, to navigate to the existing database file location, click Browse.

    Before you can import the data from an existing database, you have to detach the database file from SQL Server by using SQL Server commands. For more information, see Detach an existing database file from a previous version of ADMT and SQL Server.

    When you are finished, click Next.

  6. On the Summary page, review the results of the installation, and then click Finish.

If you use SQL Server Express, the database is automatically detached when you remove ADMT. The detached SQL Server Express database can be reused as part of another ADMT installation later. In this case, ADMT automatically attaches to the existing database that you specify during installation.

You can detach the ADMT database file from a full SQL Server instance if you have another application that you want to attach to the same database. For example, if you plan to move from a full SQL Server installation to SQL Server Express, or if you have an ADMT database file from an earlier installation that you have attached to SQL Server management tools, it needs to be detached from that database before it can be consumed by ADMT.

To detach a database, you can use the SQL stored procedure:

sp_detach_db [ @dbname = ] 'dbname'

For more information about this stored procedure call, see SQL Server documentation. For more information about how to use SQL Server Management Studio to detach the database, see How to: Detach a Database (SQL Server Management Studio (http://go.microsoft.com/fwlink/?LinkId=183994).

If you experience problems with database configuration during installation, or if you specified SQL Server Express during the ADMT v3.2 installation but want to switch to SQL Server (or vice versa) after installation, you can use Admtdb.exe. The command-line syntax for Admtdb.exe is in the following table.

You can run Admtdb.exe from an elevated command prompt on any server that can target the server computer that is running SQL Server to create the ADMT instance on that server computer.

 

Syntax Description

admtdb create /{s|server}: "Server\instance"

Installs a new ADMT database or prepares an empty database.

The /server parameter specifies the name of the SQL Server and instance to connect to for the purpose of creating the database. This is a required parameter.

admtdb upgrade /s|server: Server\Instance

Upgrades a previous version of an ADMT v3.0 or ADMT v3.1 database.

The /server parameter, which is required, specifies the name of the SQL Server and instance to connect to for the purpose of upgrading the ADMT v3.0 or ADMT v3.1 database.

noteNote
Before you upgrade the ADMT database, first open the ADMT console to verify that it is compatible with the database.

admtdb attach [/{a|attach}: "v3x database path"

Attaches an existing ADMT database to the local SQL Server Express 2005 or SQL Server Express 2008 instance.

The /attach parameter, which is required, specifies the path to a detached Admt.mdf database file.

To see Help for all Admtdb.exe command-line options, at the command prompt, type admtdb /?.

If you began the migration by using a local SQL Server Express database and then configured a remote instance of a SQL Server database, and you need to switch back to using a local SQL Server Express database, complete the following procedure. In this case, the ADMT database file is already attached to the SQL Express instance. Therefore, there is no need to explicitly reattach it.

If you began the migration by using SQL Server and you want to switch to SQL Server Express, see Reuse an existing ADMT database from a previous installation.

Membership in Administrators, or equivalent, is the minimum required to complete this procedure. Review details about using the appropriate accounts and group memberships at Local and Domain Default Groups (http://go.microsoft.com/fwlink/?LinkId=83477).

  1. On the local computer, click Start, point to Administrative Tools, and then click Services.

  2. In the Details pane, ensure that the service hosting the SQL Server Express instance is running and that the Startup Type is set to Automatic. If you are using ADMT v3.1 and you had ADMT setup install SQL Server Express, the service name is MSSQL$MS_ADMT.

    If the service is not started or if it is not set to start automatically at system startup, click Started, right-click the name of the service, and then click Properties.

  3. On the General tab, in the Startup Type list, click Automatic.

  4. Under Service Status, click Start, and then click OK.

  5. Close Services.

  6. At the command prompt, type the following commands:

    noteNote
    The admtdb attach command is necessary only if you previously ran SQL commands to detach the local SQL Server Express instance.

    admtdb attach /{s | Server}:”Local SQL Server Express instance”
    
    admt config setdatabase /s:Server\Instance.
    

    You can now use the local database.

If you want to use an existing (detached) database from an earlier ADMT v3.0, ADMT v3.1, or ADMT v3.2 installation with a local SQL Server instance, you can complete the following procedure.

noteNote
Membership in Administrators, or equivalent, is the minimum required to complete this procedure. Review details about using the appropriate accounts and group memberships at Local and Domain Default Groups (http://go.microsoft.com/fwlink/?LinkId=83477).

  1. On the local computer, click Start, point to Administrative Tools, and then click Services.

  2. In the details pane, ensure that the service hosting the SQL Server Express instance is running and that the Startup Type is set to Automatic. If you are using ADMT v3.1 and you had ADMT setup install SQL Server Express, the service name is MSSQL$MS_ADMT.

    If the service is not started or if it is not set to start automatically at system startup, click Started, right-click the name of the service, and then click Properties.

  3. On the General tab, in the Startup Type list, click Automatic.

  4. Under Service Status, click Start, and then click OK.

  5. Close Services.

  6. At the command prompt, type the following commands:

    admtdb attach /{s | Server}:”Local SQL Server Express instance” /{a | Attach}:”Path to ADMT v3.x database file to attach"
    
    admt config setdatabase /s: server\instance
    

    You can now use the existing ADMT database with the local SQL Server instance. It is not necessary to run the ADMT installation wizard again. ADMT installation can be run only once. You can perform any subsequent database configuration changes by using the admtdb.exe and admt config setdatabase commands.

    To use the Password Export Server with the new ADMT installation, you need to generate a new encryption key. For more information, see Enabling Migration of Passwords.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.