Installation and Upgrade Guides › Policy Server Installation Guide › Configuring SiteMinder Data Stores in a Relational Database › Create a Sample User Directory for Oracle or SQL Server › Create a Sample User Directory for SQL Server

Create a Sample User Directory for SQL Server

If you are using a SQL Server database as a user directory, run the smsampleusers_sqlserver.sql script to create a schema for it.

To create a sample SQL Server user directory

1. Make sure the SQL Server database instance that will contain the SiteMinder sample user data is accessible from the Policy Server machine.
2. Using the SQL Server Enterprise Manager, create the database instance for the sample user directory.

   Example: smuserstore.

3. Create the SiteMinder schema in the SQL Server database:
   1. Open smsampleusers_sqlserver.sql in a text editor and copy the contents of the entire file.
   2. Start the Query Analyzer and log in as the user who administers the Policy Server database information.
   3. In the Query Analyzer, select the smuserstore database instance from the database drop down list at the top middle of the screen.
   4. Paste the sample users schema from smsampleusers_sqlserver.sql into the query.
   5. Execute the query.