Using an Existing SQL Server to Store the Alarm and Event 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 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.

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.