Set Up a Smart Instrumentation Database for SQL Server - Intergraph Smart Instrumentation - Installation & Upgrade - Intergraph

Intergraph Smart Instrumentation Installation and Upgrade Guide

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Installation & Upgrade
Smart Instrumentation Version
2018 (12.0)

 The paths you specify in this procedure refer to the database server local folders (non-network folders).  Do not use network drives or network server names in the paths.

  1. On your Windows Start menu, navigate to the Intergraph Smart Instrumentation program icons and click DB Setup Utility.

  2. On the Microsoft SQL Server Connection dialog box, under Server name, do one of the following:

    • Accept the server name (or the instance name if the instance is not the default instance) that the software retrieves from the Intools.ini file, created during Smart Instrumentation installation.

    • Type the required name of the target database server machine or another named instance to which you want to connect for the Smart Instrumentation database setup.

  3. Under System Administrator logon name, type your System Administrator name.

  4. Under System Administrator logon password, type the appropriate password if required or leave this field empty if the password is not required.

  5. Click Connect to connect to the SQL Server database on your server machine and open the Target Database Parameters dialog box, where you can set parameters for the target Smart Instrumentation database and start the database setup process.

    • You must have full System Administration Roles to access DBSetup. The DB setup application (.exe) is found in the folder where you installed Smart Instrumentation. By default that is; C:\Program Files (x86)\SmartPlant\Instrumentation.

    • If you changed the Server name setting, when you click Connect, in the [Database] section of the Intools.ini file, the software changes the ServerName parameter, and updates the Server parameter in the current SQL Server ODBC profile.

  6. Under Target database name, type the name of the Smart Instrumentation database for which you want to run the setup process.

    SHARED Tip The Smart Instrumentation database name must be unique within your SQL Server that you specified on the Microsoft SQL Server Connection dialog box.

  7. Under Admin schema, accept the default Admin schema logon name SPI_DBAMN or modify the name as you require, provided that you type a setting that is different from the Admin schema logon password.

    • The logon name can only start with a letter and may not contain spaces.  You can use an underscore (_) to indicate a space.

    • If this is the first database setup for Smart Instrumentation in the current SQL Server database, the logon name must be unique. If you have already setup a Smart Instrumentation database in the current SQL Server, you must create a new instance for the new Smart Instrumentation database setup.

    • If you want to define a new logon name, you must also define a new logon password, different from the logon name.

  8. Accept the default Admin schema logon password SPI_DBA or modify the password as you require, provided that you type a setting that is different from the Admin schema logon name.

    • The logon password can only start with a letter and may not contain spaces.  You can use an underscore (_) to indicate a space.

    • If this is the first database setup for Smart Instrumentation in the current SQL Server database, the logon name must be unique. If you have already setup a Smart Instrumentation database in the current SQL Server, you must create a new instance for the new Smart Instrumentation database setup.

    • The software automatically converts all the password characters to upper case.  This means that after completing the database setup, if you need to connect to the Smart Instrumentation database externally, you must enter the Admin schema logon password using upper-case characters.

  9. In the subsequent boxes, accept the default parameters or modify them as needed.

    • If you change the default file size definitions, make sure the total file size that you specify does not exceed the available empty space on your selected disks.  The default is 70 MB, which includes the size of the file for the recommended initial size of the Admin data and indexes, and Smart Instrumentation database log file.

    • Each of the file names must be a legal name.

    • Each file name must be unique within your database.  Special characters are not supported.

  10. Click OK and make sure the database setup process is completed successfully.

  • If the database setup process is not successful, you cannot use the Smart Instrumentation database and must manually clean up the SQL Server database before running the DB Setup Utility again.  For details, see Clean Up the SQL Server Database.

  • On SQL Server, the DB Setup Utility automatically clears the Enforce password policy check box for each Smart Instrumentation schema login created in the instance.  If your company policy requires that this check box is selected, after completing the database setup, select the Enforce password policy check box for the Smart Instrumentation SPI_login, which is created automatically and shared for all Smart Instrumentation databases, and the Admin schema login, whose name you defined during the current database setup.  You will have to select the Enforce password policy check box every time you create other logins for Smart Instrumentation schemas.  The Domain schema and View-Only Domain schema logins are created when initializing a domain; the As-Built schema login — when creating an owner operator domain; the Project and Combined Project schema logins — when creating a project.  For details about database schemas, see Smart Instrumentation Database Schemas (see ) in the Smart Instrumentation Configuration and Maintenance help.