Installation and Upgrade Guides › Policy Server Installation Guide › Configuring SiteMinder Data in a Relational Database › Schema Files for Relational Databases › SQL Server Schema Files

SQL Server Schema Files

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

• policy_server_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_token.sql

  Creates the schema for storing token data, such as Encotone TeleID data, in a SQL Server database.

• sm_mssql_ss.sql

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

• 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 policy_server_home\xps\db:

• SQLServer.sql

  Creates the XPS schema for a SQL Server policy store.