Installing SmartPlant Instrumentation on Microsoft SQL Server - 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)

SmartPlant Instrumentation is designed to use data stored in databases to construct and maintain your engineering data.  Therefore, before you install SmartPlant Instrumentation you need to perform some preparatory procedures such as installing the SQL Server database server/client and configuring SmartPlant 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 SmartPlant Instrumentation components.

  4. Creating an initial SmartPlant Instrumentation database by (running the DB Setup Utility or using Wizard name in SmartPlant Engineering Manager (refer to SmartPlant Engineering Manager documentation for the database setup procedure).

  5. Creating a new SmartPlant Instrumentation domain.

First, you install and configure the database server where SmartPlant Instrumentation will store your data.  Then you install the SQL Server client through which SmartPlant 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 SmartPlant 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 SmartPlant 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 SmartPlant Instrumentation Database Setup for SQL Server.

The final stage is to initialize a new SmartPlant 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 SmartPlant 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