Learn how to migrate the the TMSM database from the default Microsoft SQL Express to a standalone Microsoft SQL server.
Do the following steps for TMSM database transfer:
- On the TMSM server, stop the SQL Server.
- Go to [Microsoft SQL server ]\[XXXX].TMSM\MSSQL\DATA folder.
- Copy the following files to the remote SQL server:
- db_TMSM
- db_TMSM_log
- On the remote SQL server, open the SQL Management Studio.
- Click Databases > Attach.
- Go to Attach Databases and add db_TMSM.
- On the TMSM sever machine, stop the following services:
- Trend Micro Security for Mac
- ActiveMQ for Trend Micro Security
- Open the Registry Editor.
- Modify the “DBServer” registry entry to the remote SQL server name or IP address.
- 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.
- 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.
- Start the following services:
- Trend Micro Security for Mac
- ActiveMQ for Trend Micro Security
- Log in to the OfficeScan server console to verify that you can now open the TMSM console from the Plug-ins page.