To manually create the AA databases:
- Install Active Administrator server and console before creating the databases.
- Create a blank database named ActiveAdministrator.
- Using SQL Server Management Studio run the Create Database SQL scripts from the Active Administrator install directory against the blank ActiveAdministrator database.
The database creation script is by default, the following: \Program Files\Quest\Active Administrator\Server\CreateDatabase.sql - Create groups in AD and add Logins as per the instructions in the following KB Article:
https://support.quest.com/active-administrator/kb/sl3964 - Create a blank database named ActiveAdministratorArchive.
- Using SQL Server Management Studio run the Create Database SQL scripts from the Active Administrator install directory against the blank ActiveAdministrator database.
- Run the AA Configuration Wizard and specify to connect to the existing ActiveAdministrator and ActiveAdministratorArchive databases.
- Start Active Administrator Console complete the setup
If you need to create databases for a different version of Active Administrator, contact Support to obtain the appropriate SQL scripts for the version of Active Administrator that you are using