Installation and Upgrade Guides › Policy Server Installation Guide › Configuring SiteMinder Data in a Relational Database › Configure SQL Server Data Stores › How to Store Audit Logs in SQL Server › Create the Audit Log Schema
Create the Audit Log Schema
You create the logging schema so the SQL Server database can store audit logs.
To create the audit log schema
- Open sm_mssql_logs.sql in a text editor and copy the contents of the entire file.
- Start the Query Analyzer and log in as the user who administers the Policy Server database.
- Select the database instance from the database list.
- Paste the schema from sm_mssql_logs.sql into the query.
- Execute the query.
The SiteMinder audit log store schema is created in the database.