Alarms and Events SQL Configuration

About the Database Configuration

This section describes about configuring Alarms and Events Archiving.

You must configure Historian to make use of an existing Microsoft SQL Server. For more information about Microsoft ® SQL Server ®, refer to Microsoft® SQL Server®.

Historian's database configuration is determined at install time. As part of the installation process, Historian will prompt you to provide the valid details of an existing SQL Server.

Note: Upgrade to the latest version of Historian. During the installation process, provide the valid connection information to the SQL Server.

Using an Existing SQL Server to Store the Alarms and Events Archiver

Before you begin

Note:

If you have chosen to connect Proficy Historian to a remote SQL Server, you must ensure the following conditions are met:

  • The Historian Alarm Archiver service must be run on a user account that has privileges to log into the SQL Server using Windows Authentication.
  • The Default Backup Path, found on the Archive page, must be a shared directory that is accessible to both the Historian Data Archiver and the remote SQL Server. It is recommended that this shared directory be placed on the same computer as the Historian Data Archiver service.

Procedure

  1. Select the Specify SQL Server Instance option
  2. In the Server Name, Database Name, Admin User, and Admin User Password fields, enter the values.
  3. Select the Use default SQL path as data and log path option if you want to place the data and log files at the default location as the SQL Server.
    If you want to install the data and log files at a different location, cancel the selection and in the Alarms Data Path and Alarms Log Path fields, provide the path to place the data and log files.