How Do I Prepare the SQL Server Database for Mailbox-Enabling (If AD is Configured for a Resource Forest and a User Forest)? (27453)

This section applies only if your AD/Exchange environment is configured for a resource forest and a
user forest, with corresponding user accounts. In that case, you must configure the Global Default Settings in
Notes Migration Manager, and then prepare (or verify) the values in a column of the exported
directory data, for the Data Migration Wizard to properly associate the resource accounts with the
user accounts and properly enable mailboxes.

Before you begin, you must determine which column in the SQL database will correspond to which AD
attribute from the User Forest, for the wizard to match corresponding user accounts in the resource forest and user
forest. The column (AdSearchCol) and attribute (AdAttribute) are both specified in the
[ActiveDirectory2] section of the Global Default Settings of Notes Migration Manager:

•   AdSearchCol: The column in the SQL database whose values the program should search for each
particular AdAttribute value, to match corresponding user accounts in the resource forest and user
forest. Note that the column specified here and its per-user values must exist before the Data
Migration Wizard is run.

IMPORTANT: In the current MNE version, this AdSearchCol parameter value must be set to
SearchKey2 (the default for this parameter) for the mailbox-enabling process to succeed.

•   AdAttribute: The AD attribute whose values the program should read in the AdSearchCol column of
the SQL database, to match corresponding user accounts in the resource and user forests. For example:

[ActiveDirectory2]
AdSearchCol=SearchKey2
AdAttribute=userPrincipalName

... tells the wizard to match AD objects with users such that the value of each AD object’s
userPrincipalName attribute matches the value of the corresponding user’s SearchKey2 column in the
SQL database.

To configure the Global Default settings:

1   Within Notes Migration Manager, select File | Global Default Settings. The program then opens
the program’s configuration settings into Windows Notepad. Within Notepad, the settings look like
the contents of an INI file, but they are actually saved as a part of the SQL database rather than
as an independent INI file.

2   In the [ActiveDirectory2] section, set the appropriate parameter value for AdAttribute, as
described above.

3   Close Notepad. Notes Migration Manager will then copy the new parameter value back into the SQL
database.

If you need to enter or edit the AdSearchCol column values in the SQL database:

1   Within Notes Migration Manager, in the Export Notes Directory screen: Click Export objects to
TSV. A dialog box will prompt you for a destination folder and filename for the exported file.

2   Use Microsoft Excel (or some other program that can edit a tsv-format file) to enter or edit
the contents of the column you have designated as the AdSearchCol column.

3   In the Export Notes Directory screen: Click Import objects from TSV to import the edited .tsv
file into the SQL database. A dialog box will prompt you for the filename and its location.