Install ADMT v3.1

Article
07/02/2012

Applies To: Windows Server 2008

The Active Directory Migration Tool version 3.1 (ADMT v3.1) uses SQL Server 2005 Express Edition as its default, underlying data store. You can use ADMT with the default local database installation, or you can use another SQL Server database installation that you have previously configured.

Prerequisites for installing ADMT

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

In Control Panel, select Add or Remove Programs to remove all versions of ADMT that are earlier than ADMT v3.1.

ADMT v3.1 does not support an upgrade from a previous version of ADMT.
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.

Although you can use ADMT v3.1 to migrate accounts and resources from Active Directory environments earlier than Windows Server 2008, you can install ADMT v3.1 only on a server running Windows Server 2008.

In addition to running Windows Server 2008, the server computer that you use to install ADMT v3.1 must not be installed under the Server Core installation option for Windows Server 2008 or be running as a read-only domain controller (RODC).
If you do not plan to use the local database installation, configure another SQL Server database installation with an ADMT instance. For more information about creating an ADMT instance on a SQL Server database, see Install ADMT by using a preconfigured SQL Server database.

Installing ADMT by using the default database store

You can use the default database store or a preconfigured SQL Server database to install ADMT v3.1. The most common and recommended installation method is to use the default database store that the Active Directory Migration Tool Installation Wizard configures automatically.

Note

The following procedure describes setup options for configuring how to install ADMT v3.1 with the default database store on a computer that is running Windows Server 2008. 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 (https://go.microsoft.com/fwlink/?LinkId=83477).

To install ADMT by using the default database store

From the download location (https://go.microsoft.com/fwlink/?LinkId=75627), 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 instance (MS_ADMT) is created on the local computer. Note ADMT v3.1 setup installs SQL Server 2005 Express Edition locally by default, whether it uses the software or not. However, ADMT v3.1 setup disables SQL Server 2005 Express Edition if you specify another database instance on the Database Selection page.
Database Selection	Specify the database instance to which you want to connect. We recommend Use Microsoft SQL Server 2005 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, click Use an existing Microsoft SQL Server. Specify the server to connect to in the form of Server\Instance. If you select this option, see Install ADMT by using a preconfigured SQL Server database. 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 v3.1 to migrate accounts or resources until the database instance is created and available.
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 database, click No, do not import data from an ADMT database (Default). If you want to import data from a database that you created by using ADMT v2.0 into the new ADMT v3.1 database, click Yes, please import data from an ADMT v2.0 database. If you want to import data, specify the path to the ADMT v2.0 database file. Note The ADMT v2.0 database file is named Protar.mdb. Place this file in the directory that you used formerly for your ADMT v3.0 database file. If you want to import data from a database that you created by using ADMT v3.0 into the new ADMT v3.1 database, click Yes, please import data from an ADMT v3.0 database. If you choose to import data using this option, you might have to specify the path to the ADMT v3.0 database file. Note This option appears only if an ADMT v3.0 database is not discovered during setup. ADMT v3.1 setup attempts to locate and attach to the ADMT v3.0 database files in their default location—the \MSSQL$MS\Data subfolder under the directory where ADMT v3.0 was installed. The ADMT v3.0 database files are named Admt.mdf and Admt.ldf. You have to browse and select the location only if you are importing from a database that is not discovered. If the database was not discovered by ADMT v3.1 setup, it might have to be detached from the previous ADMT v3.0 and SQL Server Desktop Edition (Windows) instance by using SQL commands. For more information about detaching a SQL database, see SQL Server Books Online. If you are importing or reusing a prior ADMT v3.1 database, the database file can be copied and reused locally. You have to perform the file copy before you install ADMT v3.1 so that the file can be discovered during ADMT v3.1 setup.
Summary	Click Finish to complete the ADMT v3.1 installation. This page summarizes the options that you selected.

Install ADMT by using a preconfigured SQL Server database

If you plan to use multiple ADMT consoles, or if you have a dedicated database server where you want to centralize your ADMT database, you can create another SQL Server database instance for ADMT instead of using the default local database. If you want to install ADMT in an instance of SQL Server 2005, install SQL Server 2005, and then use the ADMT database command-line tool (Admtdb.exe). The command-line syntax for this tool is in the following table.

You can run this tool from 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>" [/{i\|import}:"<v2 database path>"]	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. The /import parameter, which is optional, specifies the path to the Protar.mdb file from a previous ADMT v2 installation. ADMT v1 database files are not suitable for use in an import operation.
admtdb import /{s\|server}: " <Server\instance>"/{if\|importfile}: "<path to v2 database file>"	Imports an existing ADMT v2 database into an empty database. The /server parameter, which is required, specifies the name of the SQL Server and instance to connect to for the purpose of importing the ADMT v2 database. The /importfile parameter, which is required, specifies the path to the Protar.mdb file from a previous ADMT v2 installation. ADMT v1 database files are not suitable for use in an import operation.
admtdb upgrade /{s\|server}: <Server\instance>	Upgrades a previous version of an ADMT database. The /server parameter, which is required, specifies the name of the computer running SQL Server and the instance to connect to for the purpose of upgrading the ADMT v3.0 database. Note Before you upgrade the ADMT database, first verify compatibility between the database and the ADMT console by opening the ADMT console.
admtdb attach /{a\|attach}: "<v3 database path>"	Attaches an existing ADMT v3.0 database to the local SQL Express 2005 instance. The /attach parameter, which is required, specifies the path to the Admt.mdf file that was used in a previous ADMT v3.0 installation.

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

After you configure the SQL Server database, you can resume ADMT setup and specify the database that you configured in this procedure.

In the Active Directory Migration Tool Installation Wizard, on the Database Selection page, select Use an existing Microsoft SQL Server, and then specify the server to connect to that you configured in this procedure.

If you decide to use the local database after you configure a remote instance of a SQL Server database, complete the following procedure.

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 (https://go.microsoft.com/fwlink/?LinkId=83477).

To use the default local database after configuring a remote instance of a SQL Server database

On the local computer, click Start, point to Administrative Tools, and then click Services.
In the details pane, navigate to MSSQL$MS_ADMT, and then verify that the Status column displays Started, and that the Startup Type is set to Automatic. If the MSSQL$MS_ADMT service is not Started, right-click MSSQL$MS_ADMT, and then click Properties.
On the General tab, in the Startup Type drop-down list, click Automatic.
Under Service Status, click Start, and then click OK.
Close Services.
At the command prompt, type the following command:
```
admt config setdatabase s: Server\Instance
```
You can now use the default local database.

Reuse an existing ADMT v3 database from a previous installation

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