Installation and Upgrade Guides › Policy Server Installation Guide › Configuring SiteMinder Data Stores in a Relational Database › How to Configure a SiteMinder Data Store in a SQL Server Database › Create a SQL Server Database With SiteMinder Schema

Create a SQL Server Database With SiteMinder Schema

SiteMinder provides schema files to create the individual schema for storing policies, keys, logs, session data, and sample users. The following schema files are provided in the siteminder_home\db\SQL directory:

sm_mssql_ps.sql

Creates the SiteMinder policy store or key store (if you are storing keys in a different database) in a SQL Server database.

sm_mssql_logs.sql

Creates the schema for SiteMinder audit logs in a SQL Server database.

sm_mssql_ss.sql

Creates the schema for the SiteMinder session server in a SQL Server database.

smsampleusers_sqlserver.sql

(Optional) Creates the schema for SiteMinder sample users in a SQL Server database and populates the database with sample users. For example, the script includes a user named GeorgeC with a password of siteminder.

Create the database objects by running the appropriate SQL script using the SQL Server Enterprise Manager and SQL Server Query Analyzer.

Note: For more information about running SQL scripts, see your database documentation.

You can store SiteMinder data in a single SQL Server database or run each script separately to create a separate:

• policy store
• key store
• logging database
• session store
• sample users database

More Information:

Delete SiteMinder Data in ODBC Databases