Microsoft SQL Server Installation and Configuration - Intergraph Smart Engineering Manager - Installation & Upgrade - Intergraph

Intergraph SmartPlant Engineering Manager Installation and Upgrade

Language
English
Product
Intergraph Smart Engineering Manager
Search by Category
Installation & Upgrade
SmartPlant Foundation / SDx Version
Smart Electrical Version
2015 R1 (7.1)
Smart Instrumentation Version
(none)
Smart P&ID Version
7.1 (2014 R1)
Smart Engineering Manager Version
7.2 (2014 R2)

The installation and configuration procedures described in this guide include only the steps required to install and use Hexagon PPM 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.

For Smart PID users, If you intend to use the Smart P&ID Connected Workshare functionality, you must use an Oracle database rather than SQL Server.  Connected Workshare does not support SQL Server; however, Standalone Workshare does support 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. Install 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.

  • 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.