Installing Smart Instrumentation on Microsoft SQL Server - Intergraph Smart Instrumentation - 14 - Installation & Upgrade

Intergraph Smart Instrumentation Installation and Upgrade

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Installation & Upgrade
Smart Instrumentation Version
14

Smart Instrumentation is designed to use data stored in databases to construct and maintain your engineering data. Therefore, before you install Smart Instrumentation you need to perform some preparatory procedures such as installing the SQL Server database server/client and configuring Smart Instrumentation to connect to your database server. To do this, you need to have some knowledge of the database installation procedures and basic features in your Windows environment.

When working on a SQL Server platform, you maintain database-user relations by exchanging data with the database. To do this, SQL Server maintains a multi-interface system which provides the required connection along the data transfer path.

PPM All Outputs Graphic

The systems described in the above figure can be physically located on the same computer or on different computers which are connected in a local network. The installation process consists of the following major steps:

  1. Installing the SQL Server (you perform this step only if you have not installed the SQL Server on your system yet).

  2. Installing the SQL Server client (you perform this step only if you have not installed the appropriate SQL Server client on your system yet).

  3. Installing the required Smart Instrumentation components.

  4. Creating an initial Smart Instrumentation database by running the DB Setup Utility.

    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.

  5. Creating a new Smart Instrumentation domain.

First, you install and configure the database server where Smart Instrumentation will store your data. Then you install the SQL Server client through which Smart Instrumentation interfaces with the SQL Server. If you have already installed SQL Server as your database server, you may have to modify your database server settings to adapt SQL Server to support the Smart Instrumentation database.

After successfully installing the SQL Server and the SQL Server client, you install the selected components and configure the appropriate configuration files. This way you will also be able to use third-party applications such as CAD interfaces.

When Setup finishes installing the selected components, you need to configure Smart Instrumentation to connect and work with the SQL Server. At this stage, you create the filegroups and database schema logon settings. For further information about filegroups and database schema logon settings, see Smart Instrumentation Database Setup for SQL Server.

The final stage is to initialize a new Smart Instrumentation domain in SQL Server and set the initial parameters of the domain. This way you prepare the database for creating the domain plant hierarchy and defining engineering data.

Ensure that you obtain the appropriate serial number for the chosen type of Smart Instrumentation installation (standard installation or special server installation for use with IDEAL).

In this document, whenever a string appears in brackets, type the value substituting the entire string, including the brackets. For example, instead of <SQL Server home folder>, type c:\mssql