Previous Topic: Configure a SQL Server Data Source for SiteMinder

Next Topic: Create a SQL Server Data Sources on UNIX Systems

Create a SQL Server Data Source on Windows

ODBC requires that you configure a data source for the SQL Server wire protocol.

Note: This procedure only applies if the Policy Server is installed on a Windows System.

To create the data source on Windows

  1. Click Start and select Programs, Administrative Tools, ODBC Data Sources.

    The ODBC Data Source Administrator appears.

  2. Click the System DSN tab.

    System data source settings appear.

  3. Click Add.

    The Create New Data Source dialog appears.

  4. Select SiteMinder SQL Server Wire Protocol and click Finish.

    The ODBC SQL Server Wire Protocol Driver Setup dialog appears.

  5. Enter the data source name in the Data Source Name field.

    Example: SiteMinder Data Source.

    Note: Take note of your data source name. This information is required as you configure your database as a policy store.

  6. Enter the name of the SQL Server host system in the Server field.
  7. Enter the database name in the Database Name field.
  8. Click Test.

    The connection settings are tested and a prompt appears specifying that the connection is successful.

  9. Click OK.

    The SQL Server data source is configured and appears in the System Data Sources list.


Copyright © 2010 CA. All rights reserved. Email CA about this topic