Installation and Upgrade Guides › Policy Server Installation Guide › Installing Reports › How to Configure an Audit Database › Register the Audit Database with the Administrative UI

Register the Audit Database with the Administrative UI

You register the audit database with the Administrative UI to create a trusted connection between the components. Registering the audit database with the Administrative UI lets SiteMinder administrators create and manage audit-based reports.

Note: The Administrative UI can have a trusted relationship with one or more Policy Servers. However, each trusted relationship only allows one audit database connection. If you must connect to a new audit database, either delete the current connection or connect to another Policy Server to configure the connection.

To register the audit database with the Administrative UI

1. Log into the Administrative UI.
2. Click Administration, Admin UI.
3. Click Report Connections, Create Audit Report Connection.

   The Create Audit Report Connection pane appears.

   Note: Click Help for descriptions of settings and controls, including their respective requirements and limits.

4. Select the database vendor from the Database Vendor drop-down list.

   Vendor-specific fields appear.

5. Type the name of the connection in the Connection Name field.
6. Enter the audit database host system name or IP address in the Database Server Host field.
7. Enter the audit database data source information in the DSN field:
   • Oracle—Enter the Oracle Net Service name you specified when creating the audit database DSN.

     Note: The service name must be associated with the DSN you entered in the Data Tab of the Policy Server Management Console when configuring the audit database connection to the Policy Server.

   • SQL Server—Enter the DSN.

     Note: The DSN name must match the DSN you specified in the Data Tab of the Policy Server Management Console when configuring the audit database connection to the Policy Server.

8. Enter the port on which the audit database server is listening in the Database Server Port field.
9. Complete one of the following:
   • Oracle—Re–enter the Oracle Net Service Name in the Service Name field.
   • SQL Server—Enter the audit database name in the Database Name field.
10. Enter administrator credentials for the audit database in the respective fields.

    Note: The administrator credentials must match the credentials you specified in the Data tab of the Policy Server Management Console when configuring the audit database connection to the Policy Server.

11. Click Submit.

    The audit database is registered with the Administrative UI.