Active Administrator 8.6.3 - User Guide

Creating an archive database

Creating an archive database

To create a new archive database

1	Select Configuration | Archive Databases.

2	Click New.

3	Type the target SQL Server or Azure SQL Managed instance.

You can either type the instance name or browse to it. If you browse, you will see all SQL servers in your subnet that are configured to advertise their presence. If you do not see your server on the list, you must type the name.

4	Type a name for the archive database.

5	By default, Secure Sockets Layer (SSL) encryption is used for all data sent from the named server to the Active Administrator archive database. To remove encryption, clear the Encrypt Connection check box.

6	By default, the server certificate is trusted. To remove the trust, clear the check box.

NOTE: If the Trust Server Certificate check box is not selected, Active Administrator will walk the validation chain until it finds a valid authority.

7	If using an Azure SQL Managed instance, select SQL Server Authentication, enter a SQL user ID that has login privilege for the SQL Managed instance, and enter the password for the SQL account.

The characters in the password will be hidden. Each character will be represented by a displayed dot. Select Show Password to display the password.

8	Type a name for the archive.

9	Select to make this new archive database active.

If you do not select the check box, you can make it active at a later time.

10	Type a description.

11	Click Advanced.

12	If necessary, adjust the database size or file paths.

13	Select the security group type for the SQL groups.

Using the default group types is recommended.

14	If you want to override the default file locations, select the check box and locate paths for the database and log files.

15

Click OK.

Modifying archive database settings

Modifying archive database settings

To modify an archive database

1	Select Configuration | Archive Databases.

2	Select an archive database from the list.

3	Click Properties.

4	You can change the Archive Name, encryption settings, Description, and the Active/Inactive status.

5	Click Test to check if the server can connect to the selected archive database and to verify that the selected archive database is an Active Administrator® database.

6

Click OK.

Migrating data to another database

Migrating data to another database

The Active Administrator® Database Migration Tool helps you migrate data quickly and efficiently from a source database to a target database. For example, you created a new Active Administrator database and want to copy custom reports and alerts from an existing database. Use the Database Migration Tool to copy the existing data to your new database.

NOTE: The source and target databases must exist within the same version of Active Administrator. It is recommended that you back up the target database before you begin the migration.

To use the Database Migration Tool

1	Stop the Active Administrator Foundation and Active Administrator Notification services.

2	Select Start | Quest | AA Database Migration Tool.

3	On the Welcome page, click Next.

4	Type the names or browse to locate the source server and database that contains the data to migrate to the target database.

5	Type the names or browse to locate the target server and database to receive the data from the source database.

6	Click Next.

7	Select the data that you want to migrate from the source to the target database.

▪	To select all the options, click Select all.

▪	To clear all the selections, click Clear all.

8	Click Next.

9	Review the selections you made.

10	Click Finish.

11	After the data migration is finished, you can view details about the migration.

12	Click Finish.

13	Start the Active Administrator Foundation and Active Administrator Notification services.

Setting a preferred domain controller

Setting a preferred domain controller

Preferred domain controllers are used when requesting resources from Active Directory®. Normally, Active Directory assigns you the closest domain controller. You can use this feature to specify a domain controller to be used when a domain controller has not already been specified.

NOTE: Preferred domain controllers retrieve objects from Active Directory, such as a list of domain controller or a list of users. If all domain controllers in the domain are required to be scanned, such as the Inactive Accounts feature, the preferred domain controllers are not used.

You can select to verify if a preferred domain controller is offline before use. If the preferred domain controller is offline, you can choose to use the primary domain controller (PDC) of the domain or allow Active Directory to select a domain controller. The offline preferred domain controller is recorded in the server log.

To add preferred domain controllers

1	Select Configuration | Preferred Domain Controllers.

2	Click Add.

3	Type the name of the domain controller.

-OR-

Browse for and select a domain. Select a domain controller.

4

Click OK.

To delete preferred domain controllers

1	Select Configuration | Preferred Domain Controllers.

2	Click Delete All to delete all domain controllers in the list.

-OR-

Select specific domain controllers, and click Delete.