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