Learn how to manually migrate the ScanMail for Exchange (SMEX) 14.0 database to a remote SQL server, either using SQL Authentication or Windows Authentication.
Below are the prerequisites:
- The ScanMail installed should be at version 14.0.
- The original ScanMail database is hosted locally using SQL.
- Open the Command Prompt as administrator and run the following:
mkdir C:\_trendBackup mkdir C:\_trendBackup\smex_backup mkdir C:\_trendBackup\smex_backup\config cd "C:\Program Files\Trend Micro\Smex\config" copy dbcfg_* "C:\_trendBackup\smex_backup\config\"
- Verify that a backup copy of the configuration files has been created.
Below are the two (2) options to configure the database authentication for the ScanMail databases imported into the remote SQL server:
Below are some tips on how to retrieve the necessary information for editing the ScanMail configuration files.
Follow the procedure based on the database authentication method you chose in "Step 3. Configure database authentication on the remote SQL Server."
Open the ScanMail Management Console and login. Verify if all the configurations are there and no error appears on the console.
Once the ScanMail database has been successfully migrated, uninstall the ScanMail database instance in the local SQL Server. Follow this Microsoft article for the complete procedure: Uninstall an Existing Instance of SQL Server (Setup).