Creating a Database - Honeywell DOC4000 - 7.3 - Help - Intergraph

DOC4000 Help

Language
English
Product
Honeywell DOC4000
Search by Category
Help
PAS Version
7.3

The Database link in the Admin Utility is used either to create a new Microsoft SQL Server database for DOC4000 or to change the configuration for an existing database. The account used to create the database (your Windows account if you choose Windows authentication or the SQL Server account you specify if you choose SQL Server authentication) must have at least the dbcreator server role on the SQL Server where the DOC4000 database will be created. For more information about service account and database permissions, see Defining Your Service Accounts.

To create a new database:

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

  2. Click the Yes option 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 DOC4000 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 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.

  6. If you want to enable DOC4000 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 Understanding and Enabling Asset Roll Back.

  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, which identifies the primary database. For more information, see Working with Multiple Databases for Enterprise Deployments.

  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 DOC4000 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.