Setting up an administrative workstation for accessing the One Identity Manager History Database
The system prerequisites for installing an administrative workstation and the permissions required are listed in the One Identity Manager Installation Guide.
You must install a minimum of the following tools on an administrative workstation:
-
HistoryDB Manager
-
Job Queue Info
-
Designer
The following prerequisites must be in place on the workstation on which the One Identity Manager History Database schema installation and update is run:
Use the installation wizard to install One Identity Manager History Database tools on workstations for the first time.
Related topics
Installing One Identity Manager History Database components
To install components
-
Launch autorun.exe from the root directory of the One Identity Manager installation medium.
-
Go to the Other products tab, select One Identity Manager History Database, and click Install.
-
This starts the installation wizard. Select the language and click Next.
-
Confirm the conditions of the license.
-
On the Installation settings page, enter the following information.
-
Installation source: Select the directory containing the installation files.
-
Installation directory: Select the directory in which you want to install the files for One Identity Manager History Database.
NOTE: To make further configuration settings, click on the arrow button next to the input field. Here, you can specify whether you are installing on a 64-bit or a 32-bit operating system.
For a standard installation, no further configuration settings are necessary.
-
On the Assign machine roles page, define the machine roles.
NOTE: All installation subpackages are selected when you select the machine role. You can deselect individual packages.
-
On the Change service properties page, you can change the name, display name and the description for installing the One Identity Manager Service.
NOTE: This page is only shown if you have selected the Server | Job Server machine role.
- You can start different programs for further installation on the last page of the install wizard.
- To perform installation of the One Identity Manager History Database schema, start the Configuration Wizard and follow the instructions of the Configuration Wizard.
NOTE: Only perform this step on the workstation that you use to start installing the One Identity Manager History Database schema.
- Click Finish to close the installation wizard.
- Close the autorun program.
The One Identity Manager is installed for all user accounts on the workstation or server. In the default installation the One Identity Manager is installed under:
Installing a One Identity Manager History Database
IMPORTANT: The One Identity Manager database and the One Identity Manager History Database must have the same version number.
Installation of a One Identity Manager History Database is similar to that of a One Identity Manager database. For more detailed information about the system prerequisites and how to install a database, see the One Identity Manager Installation Guide.
Use the One Identity Manager History Database to set up the Configuration Wizard.
NOTE: Be aware of the following features:
-
In the Configuration Wizard, select the configuration module on the Select configuration modules page.
-
If you started the from the installation wizard, the configuration modules for the selected edition are already activated. In this case, check over the module selection.
-
If you start the Configuration Wizard directly, at this point select Data Archiving Module. Dependent configuration modules are selected automatically.
-
If you install the One Identity Manager Service for the One Identity Manager History Database using the , on the Service installation page, you can change the installation directory, name, display name, and description of the service.
The Configuration Wizard executes the following steps.
-
Installs the One Identity Manager History Database schema in a database.
The Configuration Wizard can create a new database and install the schema. Alternatively, the schema can be installed in an existing database.
-
Creates the required SQL Server logins and database users permissions for the administrative user, configuration user, and end user.
-
Creates administrative system users and permissions groups.
-
Encrypts the database.
-
Installs and configures the One Identity Manager Service with direct access to the One Identity Manager History Database for handling SQL processes.
Additional steps are required to configure the One Identity Manager History Database following the schema installation:
- Configure the database for a test, development, or live system. For detailed information, see One Identity Manager Installation Guide.
- Enter the source database in the One Identity Manager History Database.
- Set up the archiving method.
Related topics
The update process for releasing a new version
IMPORTANT: The One Identity Manager database and the One Identity Manager History Database must have the same version number.
NOTE: Read the release notes for possible differing or additional steps for updating One Identity Manager.
For detailed information about updating a database, see the One Identity Manager Installation Guide.
To update the One Identity Manager History Database to a new version
- In the Designer, carry out all consistency checks in the Database section.
- In the Designer, start the Consistency Editor by selecting the Database | Check data consistency menu item.
- In the Test options dialog click the icon .
- Activate all tests in the Database view and click OK.
-
To start the check, select the Consistency check | Run menu item.
All the database tests must be successful. Correct the errors. Some consistency checks offer repair methods for correcting errors.
- Update the administrative workstation on which the One Identity Manager History Database database schema update will start.
- Execute the autorun.exe program from the root directory on the One Identity Manager installation medium.
-
Switch to the Other products tab and select the One Identity Manager History Database entry.
-
Click Install.
This starts the installation wizard.
-
Follow the installation instructions.
IMPORTANT: On the Installation Settings page, select the directory for your current installation as the installation directory. Otherwise the components are not updated and a new installation is created in the second directory instead.
-
(From version 7.0.x or version 7.1.x) End the One Identity Manager Service on the server that processes direct database queries.
(From version 8.0.x or version 8.1.x). End the One Identity Manager Service on the update server.
- Create a back up of the One Identity Manager History Database.
- Check whether the database's compatibility level is set the 130 and change it if necessary.
-
Run a schema update of the One Identity Manager History Database.
-
Start the Configuration Wizard on the administrative workstation.
Select a user who has at least administrative permissions for the One Identity Manager database to update the One Identity Manager schema with the Configuration Wizard.
-
Use the same user that you used to initially install the schema.
-
If you created an administrative user during schema installation, use that one.
-
If you selected a user with Windows authentication to install the schema, you must use the same one for updating.
NOTE: If you want to switch to the granular permissions concept when you upgrade from version 7.0.x, 7.1.x or 8.0.x to 8.1.4, you will also require an installation user in accordance with Permissions for the One Identity Manager History Database on a SQL Server.
After updating One Identity Manager, change the connection parameters. This affect the connection credentials for the database (DialogDatabase), for example, the One Identity Manager Service, the application server, administration, and configuration tools, web applications and web services, and the connection credentials in synchronization projects.
If you want to switch to granular permissions when you update from 8.1.x, contact support. To access the Support Portal, go to https://support.oneidentity.com/identity-manager/.
-
(From version 7.0.x or version 7.1.x) Update the One Identity Manager Service on the server that processes direct database queries.
(From version 8.0.x or version 8.1.x). Update the One Identity Manager Service on the update server.
-
Execute the program autorun.exe from the root directory on the One Identity Manager installation medium.
-
Change to the Other products tab and select the One Identity Manager History Database entry.
-
Click Install.
This starts the installation wizard.
-
Follow the installation instructions.
IMPORTANT: On the Installation Settings page, select the directory for your current installation as the installation directory. Otherwise the components are not updated and a new installation is created in the second directory instead.
NOTE: After updating a One Identity Manager History Database installation from version 7.0.x or Version 7.1.x, the One Identity Manager History Service is not registered.
Register the service manually. Run the following command on the command line in administrative mode:
sc create "HDBService" binpath= "<path>\vinetworkservice.exe" displayname= "One Identity Manager History Service"
sc description "HDBService" "One Identity Manager History Service"
-
Check the One Identity Manager Service‘s login information. Revert to the original settings if the One Identity Manager Service did not initially use the local system account for logging in. Specify the service account to use.
-
Start the One Identity Manager Service on the update server.