Creating the Database - PAS ICS Integrity - 7.3 - Installation & Upgrade - Intergraph

ICS Integrity Installation Guide

Language
English
Product
PAS ICS Integrity
Subproduct
ICS
Search by Category
Installation & Upgrade
PAS Version
7.3

After running the Integrity setup program and validating your license, you need to create and configure the database using the Admin Utility.

Attention Integrity customers who plan to upgrade to Experion PKS R430. Experion PKS R430 uses Microsoft SQL Server 2012 as its application database. On any Integrity Data Collector importing R430 data, SQL Server 2012 or later is required. If you have any questions or concerns, please contact Technical Support for assistance.

To create a new database:

  1. In the Admin Utility, click the Database link.

  2. Click Yes to specify that a new database will be created.

  3. If you want a location other than the default location for the database files, specify the new location in the Location field. The default location depends on the Microsoft SQL Server installation location.

  4. In the Database Connection area, indicate the Computer name (SQL Server name) and Database name. If the Microsoft SQL Server installation where the Integrity 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.

  5. In the Authentication area, indicate whether Integrity 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 be a member of the dbcreator (min) or sysadmin fixed server role and must be assigned to the db_owner database role. Use SQL Server Management Studio to assign the db_owner database role to the account you specify.

  6. If you want to enable Integrity to support a large number of users, check the Enable SQL Server managed session state check box in the Additional Configuration section. The default setting is unchecked.

  7. If you want to enable import roll back, check the Enable Asset Roll Back check box in the Additional Configuration section. Then, click Yes on the Confirm Creating Additional Database window.

    Asset Roll Back allows administrators to roll back to a previously imported set of data in the event that the most recent import of data is old, invalid, or corrupted. For more information, see the Administration Guide.

  8. Click Save.

  9. Click OK on the Database Creation confirmation message window. The Database ID window is displayed.

  10. If you want to use multiple databases, specify a unique ID number for the database. If this database is the only database, leave the value set to 1. For more information, see Configuring Multiple Databases.

  11. Click OK to close the Database ID window and create the database. When the process finishes creating the database, a confirmation message is displayed.

  12. Click OK to close the confirmation window.

  13. If a message is displayed that indicates the Integrity services must be restarted, complete the following steps:

    1. Click OK to close the restart services message window.

    2. Click the Service Administration link.

    3. In the Select a Service area, select IntegrityDataCollector2, and restart it.

    4. In the Select a Service area, select PAS WebFileService, and restart it.