Connect to the Domain Schema on SQL Server - Intergraph Smart Instrumentation - 13.1 - Administration & Configuration - Intergraph Process, Power & Marine Documentation

Intergraph Smart Instrumentation Configuration and Maintenance Guide (2019)

PPMProduct
Intergraph Smart Instrumentation
PPMCategory_custom
Administration & Configuration
Version_SPI_custom
13.1
  1. On the menu bar, click File > Database Type Test and Query.

  2. Do one of the following:

    • To connect to the Admin schema whose parameters are defined in the Intools.ini file on the current client machine, click Actions > Use INI File.
      The software automatically retrieves the connection parameters from the Intools.ini file for the Admin schema.

    • To connect directly to the target Domain schema without specifying the Admin schema parameters first, under Database type, select SQL Server.

    • When connecting to a Domain schema in a database that is located on another machine, make sure that the appropriate ODBC profile exists on the current machine.

    • The ODBC driver box must display MSS.  This value is retrieved from the Intools.ini file, where it appears in the [Database] section as the DBMS parameter value.  Make sure that in the MSS value of the DBMS parameter appears in upper case.  Otherwise, it is not possible to work with specifications in Smart Instrumentation.

  3. Under Connection settings, do the following:

  4. In the Schema logon name box, type the target Domain schema logon name specified by the System Administrator when initializing the domain.

  5. In the Schema logon password box, type the target Domain schema logon password specified by the System Administrator when initializing the domain.

  6. Enter or modify the DBParm string using the following values:

    DBParm=ConnectString='DSN=<ODBC profile name>;UID=<Domain schema logon name>;PWD=<Domain schema logon password>',DisableBind=1

    If you connected to the Admin schema using the Intools.ini file parameters, the DBParm string is retrieved automatically from the Intools.ini file.  When you change the logon name and password, the software does not update the DBParm string.  You must manually change the UID and PWD values to match the Domain schema logon name and password respectively.

    • For SQL Server 2014, the default ODBC profile name for SQL Server is MSS2014.

    • If the Server name and Database name boxes do not display any settings, you can leave them blank.

  7. Do one of the following:

    • Click Actions > Connect.

    • Click .

      The Results pane displays the result of the connection.  A zero (0) indicates a successful operation.  Codes that indicate a connection failure include a message explaining the reason for the failure.

See Also

Smart Instrumentation Database Schemas
Checking Database Version Compatibility