Configure a Database as a Session Store

Before configuring a relational database to store session data, make sure you have:

Created a separate session server database using sm_oracle_ss.sql or sm_mssql_ss.sql.

Configured a SiteMinder Session Server Data Source for your respective database.

To point SiteMinder to store session data in a relational database:

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.
In the Database drop-down list, select Session Server.
In the Storage drop-down list, select ODBC.
Select the Session Server enabled check box and click Apply.
In the Data Source Information field, enter the name of the data source.
Example: SiteMinder Session Data Source.

Note: This name must correspond to the name you entered in the Data Source field of the ODBC Driver Setup dialog box.
In the User Name and Password fields, enter the username and password of the database account that has full access rights to the database.
In the Confirm Password field, re-enter the password.
Specify the maximum number of database connections allocated to SiteMinder. For best performance, retain the default of 5 connections.
Click Test Connection to verify connectivity to the database server.
Click Apply to save the settings.