Summary
When you install SMEX with a remote SQL server, an account is required to establish connection. If the password for this account is changed, the password needs to be manually updated in the ScanMail configuration file.
Details
To manually update the remote SQL server account password:
- Open the command line interface and navigate to the ScanMail installation path tool folder. The default path is C:\Program Files\Trend Micro\Smex\tools.
- Use toolChangeRemoteDBPWD.exe to encrypt the new password by typing the following:
toolChangeRemoteDBPWD.exe -p <output_folder_path> -c <password>
- Replace dbcfg_SQLPassword.txt with the newly generated file. The encrypted password file can be found in the following locations:
- For noncluster server installations:
ScanMail installation path\config\dbcfg_SQLPassword.txt - For VERITAS clusters (on share disks)
ScanMail data path\config\dbcfg_SQLPassword.txt
- For noncluster server installations:
- Restart the ScanMail Master service.
- Get all the host names for all ScanMail servers and save them in a text (.txt) file.
Host name example:
ExchangeMailbox01
ExchangeMailbox02
ExchangeMailbox03
... (and so on)
File name example: Server.txt - Open the command line interface and navigate to the ScanMail installation path tool folder. The default path is C:\Program Files\Trend Micro\Smex\tools
- Batch stop all the ScanMail related services using the following commands:
- for /F %i in (Server.txt) do sc %i stop ScanMail_RemoteConfig
- for /F %i in (Server.txt) do sc %i stop ScanMail_Master
- for /F %i in (Server.txt) do sc %i stop ScanMail_SystemWatcher
- Batch change password for all the host names using the following commands:
- for /F %i in (Server.txt) do sc %i config ScanMail_RemoteConfig password=[NEW PASSWORD]
- for /F %i in (Server.txt) do sc %i config ScanMail_Master password=[NEW PASSWORD]
- for /F %i in (Server.txt) do sc %i config ScanMail_SystemWatcher password=[NEW PASSWORD]
- Batch start all ScanMail related services using the following commands:
- for /F %i in (Server.txt) do sc %i start ScanMail_RemoteConfig
- for /F %i in (Server.txt) do sc %i start ScanMail_Master
- for /F %i in (Server.txt) do sc %i start ScanMail_SystemWatcher
- Restart the ScanMail Master service.
