Historian Alarm and Event SQL Configuration

Important: You do not have the latest version of Historian! You are missing out on the newest capabilities and enhanced security. For information on all the latest features, see the Historian product page. For more information on upgrades, contact your GE Digital sales agent or e-mail GE Digital Sales Support. For the most up-to-date documentation, go here.

About the Database Configuration

This section describes about configuring Alarm and Event Archiving.

You must configure Historian to make use of an existing Microsoft SQL Server. For more information, 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 install and configure a local instance of SQL Server Express 2008 or make use of an existing SQL Server.

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

Using an Existing SQL Server to Store the Alarm and Event Archiver

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 screen, 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.
  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.