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