Installation and Upgrade Guides › Policy Server Installation Guide › Prerequisites for Running Reports Using Crystal Reports › Next Steps › Configure a SQL Server ODBC Logs Data Source

Configure a SQL Server ODBC Logs Data Source

The SiteMinder Logs Data Source allows the Policy Server to write logging messages to a SQL Server database. Crystal Reports reads messages from this database to create reports.

To create and configure the SiteMinder Logs Data Source

1. Select Programs, Administrative Tools, Data Sources (ODBC) to access the ODBC Data Source Administrator.
2. Click the System DSN tab to move it to the front.
3. Click Add.

   The Create New Data Source dialog box appears.

4. Scroll down and select SiteMinder SQL Server Wire Protocol and click Finish.

   The ODBC SQL Server Wire Protocol Driver Setup dialog box appears.

5. In this dialog, do the following:
   1. In the Data Source Name field, enter the Data Source name
   2. Example: SiteMinder Logs Data Source.

      Note: Take note of this name, as you will need it when you configure the database to store audit logs.

   3. (Optional) In the Description field, enter a description of the data source.
   4. In the Server Name field, enter the name of an existing SQL server.
   5. In the Database name field, enter the name of an existing database instance.
   6. Click Test Connect to make sure to make sure the connection works.
   7. Click OK.
6. Configure the database to store audit logs.

More Information:

Configure a Database to Store Audit Logs