Installation and Upgrade Guides › Policy Server Installation Guide › Configuring SiteMinder Data Stores in a Relational Database › Configure Policy, Key, Logging, or Session Stores › Store Keys, Logging, and Session Data in the Policy Store › Store Key, Logging, and Session Information in a SQL Server Database

Store Key, Logging, and Session Information in a SQL Server Database

To store keys, logging, and session information in a SQL Server database

1. Be sure that the SQL Server database instance that is to store the SiteMinder data is accessible from the Policy Server host system.
2. Using the SQL Server Enterprise Manager, create the database instance for the information type you want.
3. Create the SiteMinder schema in the database:
   1. Open one schema file in a text editor and copy the contents of the entire file. The schema files include:
      • sm_mssql_ps.sql
        Creates the SiteMinder policy store; or, if you are storing keys in a different database, creates a key store.
      • sm_mssql_logs.sql
        Creates the schema for SiteMinder audit logs.
      • sm_mssql_ss.sql
        Creates the schema for the SiteMinder session server.
   2. Start the Query Analyzer and log in as the user who administers the Policy Server database information.
   3. In the Query Analyzer, select the desired database instance from the database list at the top-middle of the screen.
   4. Paste the copied schema into the query.
   5. Execute the query.

      Note: Running sm_mssql_logs.sql causes warnings to display. These warnings are expected and do not cause problems with the policy store or logging database.

4. Repeat steps 2-3 for the remaining files.
5. In the Policy Server Management Console, click the Data tab to move it to the front.

   Important! If you are accessing this graphical user interface on Windows Server 2008, open the shortcut with Administrator permissions, even if you are logged into the system as an Administrator. For more information, see the release notes for your SiteMinder component.

6. Select Key Store from the Database list.
7. Select the Use the policy store database check box and click Apply.
8. Select Audit Logs from the Database list.
9. Select the Use the policy store database check box and click Apply.
10. Click Test Connection to verify connectivity to the database server.
    • If it returns a success message, click OK to save the settings and exit.
    • If it returns a failure message, go back a recheck your data source settings.