Password Encryption - Intergraph Smart Materials - Version 10.2 - Installation & Upgrade - Hexagon

Intergraph Smart Materials Installation (10.2)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Installation & Upgrade
Smart Materials/Smart Reference Data Version
10.2

Up to Smart Materials 10.1 release, database user passwords were stored as plain text in configuration files. Starting with 10.1, passwords are stored encrypted during installation by default.

  1. The encrypted password is stored in the web.config file, which can be found at:

    <Product root>\Web\DataBrokerService\Web.config

    You can find user and password under SmartPlantDefaultConnection, for example:

    <SmartPlantDefaultConnection>

          <add key="Database" value="TEST" />

          <add key="User" value="M_SERVICE" />

          <add key="Password2" value="aw7ZXJ234XD" />

        </SmartPlantDefaultConnection>

  2. If you want to apply old behavior with plain text password, remove Password2 and add Password with the plain password, for example:

    <SmartPlantDefaultConnection>

          <add key="Database" value="TEST" />

          <add key="User" value="M_SERVICE" />

          <add key="Password" value="HUGO" />

        </SmartPlantDefaultConnection>

  3. If you have installed the optional SingleSignOn Service, the encrypted password can also be found in the web.config file at:

    <Product root>\Web\SingleSingOnService\Web.config

    You can find user and password under SmartPlantDefaultConnection, for example:

    <SmartPlantDefaultConnection>

          <add key="Database" value="TEST" />

          <add key="User" value="M_SERVICE" />

          <add key="Password2" value="aw7ZXJ234XD" />

        </SmartPlantDefaultConnection>

  4. If you want to apply old behavior with plaint text password, remove Password2 and add Password with the plain password, for example:

    <SmartPlantDefaultConnection>

          <add key="Database" value="TEST" />

          <add key="User" value="M_SERVICE" />

          <add key="Password" value="HUGO" />

        </SmartPlantDefaultConnection>

Each time the M_SERVICE password changes this procedure must be applied again.