Change the Deep Security Manager database password

With Deep Security Manager for AWS Marketplace, you have the option of using a Microsoft SQL Server database or an Oracle database. Your organization's security policies may require that you periodically change the password that Deep Security Manager uses to access the database.

Change your Microsoft SQL Server password

  1. Stop the Trend Micro Deep Security Manager service on each of your Deep Security Manager instances. The Linux command to stop the service is:

    # service dsm_s stop

  2. Use SQL Server Management Studio to change the SQL user password.
  3. On each Deep Security Manager instance, modify the /opt/dsm/webclient/webapps/ROOT/WEB-INF/dsm.properties file to specify the new password. When you open this file, you will see an obfuscated value for the password, similar to this:

    database.SqlServer.password=$1$4ec04f9550e0bf378fa6b1bc9698d0bbc59ac010bfef7ea1e6e47f30394800b1a9554fe206a3ee9ba5f774d205ba03bb86c91c0664c7f05f8c467e03e0d8ebbe

    Overwrite that value with your new password (the new password will be obfuscated when the service restarts):

    Database.SqlServer.password=NEW PASSWORD GOES HERE

  4. Start the Trend Micro Deep Security Manager service on each of your Deep Security Manager instances. The Linux command to start the service is:

    # service dsm_s start

Change your Oracle password

  1. Stop the Trend Micro Deep Security Manager service on each of your Deep Security Manager instances. The Linux command to stop the service is:

    # service dsm_s stop

  2. Use your Oracle tools to change the password.
  3. On each Deep Security Manager instance, modify the /opt/dsm/webclient/webapps/ROOT/WEB-INF/dsm.properties file to specify the new password. When you open this file, you will see an obfuscated value for the password, similar to this:

    database.Oracle.password=$1$4ec04f9550e0bf378fa6b1bc9698d0bbc59ac010bfef7ea1e6e47f30394800b1a9554fe206a3ee9ba5f774d205ba03bb86c91c0664c7f05f8c467e03e0d8ebbe

    Overwrite that value with your new password (the new password will be obfuscated when the service restarts):

    Database.Oracle.password=NEW PASSWORD GOES HERE

  4. Start the Trend Micro Deep Security Manager service on each of your Deep Security Manager instances. The Linux command to start the service is:

    # service dsm_s start