Check the Connection to Your SQL Server Database Server - Intergraph Smart Instrumentation - Installation & Upgrade - Hexagon PPM

It is recommended that you check the connection to the Admin schema of SmartPlant Instrumentation in your database server and make sure that you can establish a reliable connection to the database before running SmartPlant Instrumentation.

1. Click Start > Programs > Intergraph SmartPlant Instrumentation > Internal Setup Utility .

2. On the menu bar, click File > Database Type Test and Query.

3. On the menu bar, click Actions > Use INI file to load the settings entered by SmartPlant Instrumentation Setup in the [Database] section of the Intools.ini file.

4. On the menu bar, click Actions > Connect .

5. Under Results, make sure the following information appears:

6. Result Code: 0
   The number of rows affected: 0
   Database vendor's error code: 0
   The database vendor's error message.
   The database-vendor specific: Microsoft SQL Server

   If you do not achieve these results, contact Intergraph Support.