Microsoft SQL Server Installation and Configuration - Intergraph Smart Instrumentation - Installation - Intergraph

Intergraph Smart Instrumentation Installation and Upgrade Guide

PPMProductFamily
Engineering and Schematics
PPMProduct
Intergraph Smart Instrumentation
PPMCategory
Installation
SPFVersion_custom
Version_SPI_custom
2018 (12.0)
Version_SPPID_custom
(none)
Version_SPEM_custom
(none)

The installation and configuration procedures described in this guide include only the steps required to install and use Smart Instrumentation software in the Microsoft SQL Server environment. Therefore, it is recommended that you refer to your Microsoft SQL Server User's Guide for additional information about Microsoft SQL Server.

Because system configurations, database software, and individual company standards vary, use this section as a checklist instead of step-by-step instructions. For specific configuration questions, contact Intergraph Customer Support.

  1. Using the Typical installation, load the Microsoft SQL Server software on your database server.

  2. Configure SQL Server to create your custom database. You will need to provide the database node name, Administrator user name, and Administrator password when performing the configuration.

  • SQL Server Client is required on any computer running Smart Instrumentation on which you intend to perform administrative activities such as site, plant, or project creation, or on any computer on which backup or restore operations are performed.

  • Microsoft Data Access Components (MDAC) 2.8.1 is required if you are using a SQL Server database.

  • When creating and configuring your databases, keep in mind that plant structures must be created in a SQL Server database separate from the site server database and that each plant must be in its own database. Database node names may not include periods (.) or spaces.

  • If the backup location for your SQL site is located on a separate computer from your database, you must modify the logon information for the SQL Server services using the procedure that follows.

  • When creating a database for Smart Engineering Manager, the database name may not include periods (.) or spaces.

  • Create Microsoft SQL Server databases with locale-specific collation settings and ensure that all interacting databases have the same collation settings.