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

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 psw2 attribute in the the databases.xml file, which can be found at:

   <Product root>\DeploymentFolder\databases.xml

   You can find user and password in the <Databases> section, for example:

   <?xml version="1.0" encoding="utf-8"?>

   <Databases>

     <database name="XYZ" user="M_SERVICE" psw2="aw7ZXJ234XD" />

   </Databases>

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

   <database name="XYZ" user="M_SERVICE" psw="HUGO" />

3. Additionally, 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>

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

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