SQL Server Data Sources Configuration

The only configuration you normally need to do for the SQL server is to specify the name of remote computers from which data may be logged.

  1. Click Start on the Windows task bar.

  2. Select Settings>Control Panel.

  1. Click the ODBC Sources icon image\help0024.gif.

The ODBC Data Source Administrator dialog box opens.

  1. Select the System DSN tab.

  2. Select either:

CIMPLICITY Logging - Alarms or

CIMPLICITY Logging - Points.

  1. Click Configure.

A first Microsoft SQL Server DSN Configuration wizard displays.

  1. 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.

  1. 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.

  1. Click Next.

  1. Finish configuration leaving the defaults on the remaining dialog boxes.

More information

image\Buttongraysm.png

ODBC configuration.