Trend Micro Control Manager has a utility called DBConfig that allows you to configure the Trend Micro Control Manager SQL database. To use the Trend Micro Control Manager DBConfig utility to configure Trend Micro Control Manager to point to a specific SQL database with specific settings, run the following command:
dbconfig -DBName=”db_controlmanager” -DBAccount=”tmcm” -DBPassword=”novirus” – mode=”SQL”
This points the Trend Micro Control Manager database. The DBConfig utility has the following command line switches (parameters):
- DBName=”database name” (Used to specify the name of the database)
- DBAccount=”database account” (Used to specify the SQL username)
- DBPassword=”database password” (Used to specify the SQL database password)
- Mode=”SQL” (Used to specify the SQL authentication mode. This can be either “SQL” or “WA” [SQL authentication or Windows authentication])
- DBHost=”IP address/hostname” (Used to specify the IP or hostname of the SQL server)
- Owner (Typing dbconfig -Owner changes the owner of the TMMC database to “dbo”)