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

Create a technical support case if you need further support.

Migrating the Security for Mac (TMSM) database to a standalone Microsoft SQL server

    • Updated:
    • 14 Nov 2016
    • Product/Version:
    • Trend Micro Security for Mac 1.5
    • Trend Micro Security for Mac 2.0
    • Platform:
    • Macintosh Leopard
    • Macintosh Lion
    • Macintosh Mavericks
    • Macintosh Mountain Lion
    • Macintosh Snow Leopard
Summary

Learn how to migrate the the TMSM database from the default Microsoft SQL Express to a standalone Microsoft SQL server.

Details
Public

Do the following steps for TMSM database transfer:

  1. On the TMSM server, stop the SQL Server.
  2. Go to [Microsoft SQL server ]\[XXXX].TMSM\MSSQL\DATA folder.
  3. Copy the following files to the remote SQL server:
    • db_TMSM
    • db_TMSM_log
  4. On the remote SQL server, open the SQL Management Studio.
  5. Click Databases > Attach.

  6. Go to Attach Databases and add db_TMSM.
    Adding db_TMSM on Databases
  7. On the TMSM sever machine, stop the following services:
    • Trend Micro Security for Mac
    • ActiveMQ for Trend Micro Security
  8. Open the Registry Editor.
  9. Modify the “DBServer” registry entry to the remote SQL server name or IP address.
    DBServer registry entry modification
  10. Use the PsExec tool and run “psexec -s -i cmd.exe” to launch the command prompt with System privileges. You can download PsExec tool from Microsoft.
    PsExec tool use
  11. In the command prompt, run TMSMDBPassword.exe. This will update the TMSM database password in the registry. The new password should be the same as the “sa” password on the remote SQL server.
    running
  12. Start the following services:
    • Trend Micro Security for Mac
    • ActiveMQ for Trend Micro Security
  13. Log in to the OfficeScan server console to verify that you can now open the TMSM console from the Plug-ins page.
Premium
Internal
Rating:
Category:
Migrate
Solution Id:
1112270
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.