Installation and Upgrade Guides › Policy Server Installation Guide › Configuring SiteMinder Data Stores in a Relational Database › Policy Store Schema Considerations › SQL Server Schema Files

SQL Server Schema Files

The following SQL Server schema files are provided in the siteminder_home\db\SQL directory:

siteminder_home

Specifies the Policy Server installation path.

sm_mssql_ps.sql

Creates the schema for a policy store and key store.

Note: If you are storing keys in a different database, this schema file creates the schema for the key store data.

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 Session Server in a SQL Server database.

Note: If you do not plan on storing Unicode characters in the Session Server, use this file.

sm_mssql_ss.sql.unicode

Creates the schema for the Session Server in a SQL Server database.

Note: If you plan on storing Unicode characters in the Session Server, use this file.

smsampleusers_sqlserver.sql

Creates the schema for SiteMinder sample users in a SQL Server database and populates the database with sample users. For example, if you look in the script, you can see a sample user named GeorgeC with a password of siteminder.

The following SQL Server schema file is provided in siteminder_home\xps\db:

SQLServer.sql

Creates the XPS schema for a SQL Server policy store.