Changing the Configuration for an Existing Database - PAS ICS Integrity - 7.3 - Help - Intergraph

The Admin Utility allows you to change how an existing database is configured. For example, you can enable asset roll back or managed session state.

To change the configuration for an existing database:

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

2. Click the No option to specify that an existing database should be modified.

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

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

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

7. Click Save.

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