Previous Topic: How to Configure the Policy Store

Next Topic: Configure a SQL Server Data Source for SiteMinder

Create the SiteMinder Schema

You create the SiteMinder schema so that SQL Server database can store policy, key, token session, and audit logging information.

The following warnings are displayed when running the policy store and audit logging schema files and do not affect the policy store configuration:

To create the SiteMinder Schema

  1. Start the Query Analyzer and log in as the person who administers the Policy Server database.
  2. Select the database instance from the database list.
  3. Open sm_mssql_ps.sql in a text editor and copy the contents of the entire file.
  4. Paste the schema from sm_mssql_ps.sql into the query, and execute the query.

    The policy and key store schema is added to the database.

  5. Open SQLServer.sql in a text editor and copy the contents of the entire file.
  6. Paste the schema from SQLServer.sql into the query, and execute the query.

    The policy store schema is extended.

  7. Repeat steps three and four to use the policy store as a logging database, token store, and session store.

    The respective schema files are:

    The respective SiteMinder schema is added to the database.

    Note: You are not required to configure the policy store to store additional SiteMinder data. You can configure individual databases to function as one or more separate logging databases, key stores, token stores, and session stores.

    The database can store SiteMinder data.


Copyright © 2010 CA. All rights reserved. Email CA about this topic