Installation and Upgrade Guides › Policy Server Installation Guide › Prerequisites for Running Reports Using Crystal Reports › Next Steps › Configure a SQL Server ODBC Crystal Reports Data Source

Configure a SQL Server ODBC Crystal Reports Data Source

The Crystal Reports Data Source allows Crystal Reports to read messages from the Policy Server’s SQL Server logging database.

Note: You will need a SQL Server client installed on the Crystal Reports’ machine to use the SQL Server client driver in this section.

To create and configure the Crystal Reports Data Source

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 SQL Server and click Finish.

   The Create New Data Source to SQL Server dialog box appears.

5. In this dialog, do the following:
   1. In the Name field, enter SQL Serv CR Reports Data Source.

      Note: You must enter this name exactly as shown for the reports to work properly.

   2. (Optional) In the Description field, enter a description of the data source.
   3. In the Server field, enter the name of an existing SQL server.
   4. Click Next.
   5. The second Create New Data Source to SQL Server dialog box appears.
6. In this second dialog, do the following:
   1. Select the With SQL Server authentication using a login ID and password entered by the user radio button.
   2. Enter the login name and password of the SQL Server user who administers the Policy Server’s logging database and click Next.
7. In the third dialog, do the following:
   1. If you do not want to connect to the default database, check Change the default database to, and select the database instance from the drop-down menu.

      Example: logs.

   2. Click Next.
8. In the fourth dialog, click Finish.
9. (Optional) In the ODBC Microsoft SQL Server Setup dialog, click Test Data Source to make sure the connection works and click OK.

   The configuration is complete.

   You can now edit the SiteMinder reports files to use this Crystal Reports data source.

More Information:

Modify SiteMinder Reports to Use the Crystal Reports Data Source