Clean Up the SQL Server Database - Intergraph Smart Instrumentation - Installation & Upgrade - Hexagon PPM

SmartPlant Instrumentation Installation and Upgrade Guide

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Installation & Upgrade
Smart Instrumentation Version
2016 SP1 (11.0.1)

 The following procedure allows you to clean up the SQL Server 2014 database by using Microsoft SQL Server Management Studio options.

  1. In Microsoft SQL Server Management Studio, on the Connect to Server dialog box, do the following:

    1. From the Server type box, select Database Engine.

    2. Connect as SA to open the Object Explorer.

  2. In the <server name> > Databases folder, do the following:

    1. Expand the Security > Users hierarchy of the target SmartPlant Instrumentation database to display the database user login names.

    2. Remember the Admin schema login name (you will need to delete the Admin schema login).

    3. In the Databases folder, right-click the target SmartPlant Instrumentation database and click Delete.

      SHARED Tip When deleting the database, the software also deletes the appropriate filegroups, the INTOOLS_ENGINEER role, and the SmartPlant Instrumentation database schemas (database users).

  3. In the <server name> > Security folder, expand the Logins folder of the target SmartPlant Instrumentation database and do one of the following:

    • If your SmartPlant Instrumentation database is the only database in the current instance, right-click and delete the following logins: SPI_login, SPIsuper, and the Admin schema login.

    • If you have other SmartPlant Instrumentation databases in the current instance, right-click and delete only the Admin schema login.

      The SPI_login and SPIsuper logins are shared for all SmartPlant Instrumentation databases created in the current SQL Server instance.