Previous Topic: Create a System DSN For Oracle

Next Topic: Installation Materials

Create a System DSN For MS SQL Server

To create a System DSN for SQL Server, follow these steps:

  1. Select Start, Programs, Administrative Tools, Data Sources (ODBC).

    The ODBC Data Source Administrator dialog appears.

  2. On the System DSN tab, click Add

    The Create New Data Source dialog appears.

  3. From the list select SQL Server, and click Finish.

    The Create New Data Source to SQL Server dialog appears.

  4. Enter the values for the Name and Description, select the Server from the drop down list, and click Next.
  5. Select With SQL Server authentication using a login ID and password entered by the user, enter the values for Login ID as irec_user and its Password, and click Next.
  6. Check the box for Change the default database to, select the database for the audit trail (where you wish to maintain the trace details), and click Next.

    Important! You can use a non master database as the default database.

  7. Click Finish.

    The ODBC Microsoft SQL Server Setup dialog appears.

  8. Click Test Datasource, to ensure successful connection.

    The SQL Server ODBC Data Source Test dialog appears.

  9. Click OK.

    The DSN to be used for the audit trail is created.


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