Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

Retaining the settings of Security for Mac (TMSM) 1.5 Plug-in after migration or reinstallation

    • Updated:
    • 16 Jun 2016
    • Product/Version:
    • Trend Micro Security for Mac 1.5
    • Platform:
    • Windows 2003 Enterprise
    • Windows 2003 Standard
    • Windows 2008 Enterprise
    • Windows 2008 Standard
Summary

Retain the TMSM Plug-in settings after migration or reinstallation.

Details
Public

To retain the TMSM Plug-in settings after migration or reinstallation:

  1. Backup the following files:
    • ..\Program Files\Trend Micro\OfficeScan\Addon\TMSM\apache-activemq\conf\activemq.xml
    • ..\Program Files\Trend Micro\OfficeScan\Addon\TMSM\apache-activemq\conf\broker.cert
    • ..\Program Files\Trend Micro\OfficeScan\Addon\TMSM\apache-activemq\conf\broker.ks
    • ..\Program Files\Trend Micro\OfficeScan\Addon\TMSM\apache-activemq\bin\win32\wrapper.conf
    • ..\Program Files\Trend Micro\OfficeScan\Addon\TMSM\ServerInfo.plist
  2. Backup the SQL server data:
    1. Login to the server as administrator.
    2. Make sure the SQL Server (TMSM) service is running as SYSTEM. If not, go to the Services Console and change this service to logon as Local System account and then restart the service.
    3. Open Command Prompt as administrator.
    4. Run the following command to login to  the TMSM instance (where ..\TMSM is the default instance by installation, change it to your corresponding instance if you have customized it):

      sqlCmd -S .\TMSM -E

      You will see "1>" on the command line

    5. Run the following command to backup the database to D drive or specify your own location and backup file name:

      BACKUP DATABASE db_TMSM TO DISK='D:\TMSM.bak';
      GO

      You should be able to see messages similar to the following on the command line if the back up is successful:

      Processed 200 pages for database 'db_tmsm', file 'db_TMSM' on file 1.
      Processed 2 pages for database 'db_tmsm', file 'db_TMSM_log' on file 1.
      BACKUP DATABASE successfully processed 202 pages in 0.289 seconds (5.701 MB/sec)

  3. Uninstall and reinstall TMSM server.
     
    You do not need to uninstall Plugin Manager (PLM).
  4. After reinstalling TMSM server, backup the following XML file:

    ..\Program Files\Trend Micro\OfficeScan\Addon\TMSM\apache-activemq\conf\activemq.xml

  5. Open the said .XML file using a text editor (e.g. Notepad).
  6. Look for "password" and copy its value. Here is the snippet:

    authenticationUser username="server" password="<value>" groups="admins" /

  7. Copy the following files you backed up on Step 1 to reinstall TMSM server:
     
    If the server IP is changed, then you just restore the password value from  the backup file.
    • ..\Program Files\Trend Micro\OfficeScan\Addon\TMSM\apache-activemq\conf\activemq.xml
    • ..\Program Files\Trend Micro\OfficeScan\Addon\TMSM\apache-activemq\conf\broker.cert
    • ..\Program Files\Trend Micro\OfficeScan\Addon\TMSM\apache-activemq\conf\broker.ks
    • ..\Program Files\Trend Micro\OfficeScan\Addon\TMSM\apache-activemq\bin\win32\wrapper.conf
    • ..\Program Files\Trend Micro\OfficeScan\Addon\TMSM\ServerInfo.plist
  8. Open the following file using a text editor:

    ..\Program Files\Trend Micro\OfficeScan\Addon\TMSM\apache-activemq\conf\activemq.xml

  9. Paste the password value you copied on Step 4. Here is the snippet:

    authenticationUser username="server" password="<value>" groups="admins" /

  10. Run the following .BAT file:

    ..\Program Files\Trend Micro\OfficeScan\Addon\TMSM\restart_TMSM.bat

  11. Decompress the InstallPackage that you can get from the following location:

    ..\Program Files\Trend Micro\OfficeScan\Addon\TMSM\TMSM_Client\tmsminstall.mpkg.zip

  12. Go to ..\tmsminstall.mpkg\Contents\Resources\conf and copy the following files:
    • ..\Program Files\Trend Micro\OfficeScan\Addon\TMSM\apache-activemq\conf\broker.cert
    • ..\Program Files\Trend Micro\OfficeScan\Addon\TMSM\ServerInfo.plist
  13. Compress the decompressed InstallPackage.
  14. Retore the SQL server data:
    1. Login to the server as administrator.
    2. Make sure the SQL Server (TMSM) service is running as SYSTEM. If not, go to the Services Console and change this service to let it logon as Local System account and restart the service.
    3. Open Command Prompt as administrator.
    4. Run the following command to login to  the TMSM instance (where ..\TMSM is the default instance by installation, change it to your corresponding instance if you have customized it):

      sqlCmd -S .\TMSM -E

      You will see "1>" on the command line

    5. Run the following command to backup the database to D drive or specify your own location and backup file name:

      RESTORE DATABASE db_TMSM FROM DISK='D:\TMSM.bak';
      GO

      You should be able to see messages similar to the following on the command line if the back up is successful:

      Processed 200 pages for database 'db_tmsm', file 'db_TMSM' on file 1.
      Processed 2 pages for database 'db_tmsm', file 'db_TMSM_log' on file 1.
      RESTORE DATABASE successfully processed 202 pages in 0.133 seconds (12.388 MB/sec).

Premium
Internal
Rating:
Category:
Install; Uninstall; Migrate
Solution Id:
1059479
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support


To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.


Need More Help?

Create a technical support case if you need further support.