Change the Deep Security Manager database password

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
• Change your Oracle password
• Change your PostgreSQL password

Change your Microsoft SQL Server password

1. On Windows, stop the Trend Micro Deep Security Manager service on each of your Deep Security Manager instances.

On Linux, the 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. On Windows, start the Trend Micro Deep Security Manager service on each of your Deep Security Manager instances.

On Linux, the command to start the service is:

# service dsm_s start

Change your Oracle password

1. On Windows, stop the Trend Micro Deep Security Manager service on each of your Deep Security Manager instances.

On Linux, the 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. On Windows, start the Trend Micro Deep Security Manager service on each of your Deep Security Manager instances.

On Linux, the command to start the service is:

# service dsm_s start

Change your PostgreSQL password

1. On Windows, stop the Trend Micro Deep Security Manager service on each of your Deep Security Manager instances.

On Linux, the command to stop the service is:

# service dsm_s stop

2. Follow instructions from your PostgreSQL documentation 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.PostgreSQL.password=$1$4ec04f9550e0bf378fa6b1bc9698d0bbc59ac010bfef7ea1e6e47f30394800b1a9554fe206a3ee9ba5f774d205ba03bb86c91c0664c7f05f8c467e03e0d8ebbe

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

   Database.PostgreSQL.password=NEW PASSWORD GOES HERE

4. On Windows, start the Trend Micro Deep Security Manager service on each of your Deep Security Manager instances.

On Linux, the command to start the service is:

# service dsm_s start