SQL Server Data Sources Configuration

Procedure

  1. Click Start on the Windows task bar.
  2. Select Settings>Control Panel.
  3. Click the ODBC Sources icon .

    The ODBC Data Source Administrator dialog box opens.

  4. Select the System DSN tab.
  5. Select either:
    • CIMPLICITY Logging - Alarms or
    • CIMPLICITY Logging - Points.
  6. Click Configure.

    A first Microsoft SQL Server DSN Configuration wizard displays.

  7. Configure the first Microsoft SQL Server DSN Configuration wizard as follows:
    1. Select the Server as follows:
    For Select
    The local machine One of the following:
    • (Local)
    • Machine Name\Proficy
    A remote machine The computer name from the drop down list.
    1. Click Next.

    A second Microsoft SQL Server DSN Configuration wizard opens.

  8. Configure the second Microsoft SQL Server DSN Configuration wizard as follows:
    Feature Check
    A Authenticate the login ID With SQL Server authentication using a login ID and password entered by the user.
    B Connect to SQL Connect to SQL Server to obtain default settings for the additional configuration options.
    Enter Description
    Login ID Valid for the selected SQL Server.
    Password Required with the log in ID.
  9. Click Next.
  10. Finish configuration leaving the defaults on the remaining dialog boxes.