The installation and configuration procedures described in this guide include only the steps required to install and use Hexagon 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.
-
Install the Microsoft SQL Server software on your database server.
-
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.