Creating the Database for the Import Data Archive - Honeywell DOC4000 - 7.3 - Administration & Configuration - Intergraph

DOC4000 Administration Guide

Language
English
Product
Honeywell DOC4000
Subproduct
Cyber
Search by Category
Administration & Configuration
PAS Version
7.3

DOC4000 uses a database to track import data archiving and to store the latest import data archive zip file for each asset. You need to specify the database to create or use for import data archiving, and the authentication method and credentials for accessing the database.

To create the import data archive database:

  1. In the Admin Utility, click the Data Archive Configuration link. DOC4000 detects whether a database for import data archiving has been created. If a database has not been specified, the Archive Data window is similar to the following image.

    admin-data-archive-db

  2. In Configuration, specify whether you want to create a new database (Yes) or use an existing database (No).

  3. In the Database Connection area, indicate the Computer Name (SQL Server name) and Database Name. If the Microsoft SQL Server installation where the import data archive database will be located is a named instance, type the server name followed with a backslash and the instance name in the Computer Name field, such as Server\Instance.

    The database name must begin with a letter or underscore. Database names can contain only letters, numbers, underscores, dashes, and periods. No special characters can be used.

  4. In the Authentication area, indicate whether DOC4000 should log in to Microsoft SQL Server using your Windows account or a specified SQL Server user ID and password. If you select SQL Server mode, type the user ID and password defined within SQL Server.

    For either authentication mode, the user account must have the dbcreator (min) or sysadmin fixed server role and must be assigned the db_owner database role. Use SQL Server Management Studio to assign the db_owner database role to the account you specify.

  5. Click Save.

After the database is created and defined, the Archive Data window displays different options so you can configure import data archiving. For more information, see Configuring the Import Data Archive.