Installation and Upgrade Guides › Policy Server Installation Guide › Prerequisites for Running Reports Using Crystal Reports › How to Configure the Policy Server for Crystal Reports › Create the SQL Server Database Schema For Stored Procedures

Create the SQL Server Database Schema For Stored Procedures

If you are using SQL Server to store reporting information, run the
SmReportStoredProcedures_SqlServer.sql script to create a schema for stored procedures in the logging database. You create the stored procedures because the report files need to extract results from the database. This script is included in the <siteminder_installation>\reports directory.

siteminder_installation

Specifies the installed location of SiteMinder.

To create the SQL Server database schema for stored procedures

1. Make sure the SQL Server logging database instance that will contain the stored procedures schema is accessible from the Policy Server machine.
2. Create the stored procedures schema in the SQL Server logging database:
   1. Open SmReportStoredProcedures_SqlServer.sql in a text editor and copy the contents of the entire file.
   2. Start the Query Analyzer and log in to SQL Server as the same user who ran the sm_mssql_logs.sql script.
   3. In the Query Analyzer, select the logs database instance from the database drop down list at the top-middle of the screen.
   4. Paste the schema for stored procedures from
      SmReportStoredProcedures_SqlServer.sql into the query.
   5. Execute the query.
3. Configure the SQL Server ODBC logs data source.

More Information:

Configure a SQL Server ODBC Logs Data Source