Installation and Upgrade Guides › Policy Server Installation Guide › Configuring SiteMinder Data Stores in a Relational Database › How to Configure a SiteMinder Data Store in a SQL Server Database › Configure a SQL Server Data Source for SiteMinder › Create a SQL Server Data Source on Windows Systems

Create a SQL Server Data Source on Windows Systems

To create a SQL Server data source on Windows systems

1. Select Programs, Administrative Tools, Data Sources (ODBC) to access the ODBC Data Source Administrator.
2. Click the System DSN tab to move it to the front.
3. Click Add.

   The Create New Data Source dialog box appears.

4. Scroll down and select SiteMinder SQL Server Wire Protocol, and click Finish.

   The ODBC SQL Server Wire Protocol Driver Setup dialog box appears.

5. In this dialog, do the following:
   1. In the Data Source Name field, enter the Data Source name.

      Example: SM SQL Server Wire DS.

      Note: Take note of your data source name, as you will need it when configuring your ODBC database as a policy store.

   2. (Optional) In the Description field, enter a description of the data source.
   3. In the Server Name field, enter the name of an existing SQL server.
   4. In the Database name field, enter the name of an existing database instance.
   5. Click Test Connect to make sure to make sure the connection works.
   6. Click OK.

   The configuration is complete. Now, point the Policy Server to use the data source you just created by configuring your ODBC database as a policy store.

More Information:

Configure an ODBC Database as a Policy Store