Modify a number of parameters in TMI.cfg to migrate a Control Manager database from a SQL 2000 server to another SQL 2000 server.
To migrate existing database to a new SQL 2000 server:
Copy the Control Manager database from the old SQL Server to the new SQL Server.
Control Manager encrypts the CFG_DM_DB_PWD value. Trend Micro recommends configuring the target SQL Server with the same authentication account used to access db_ControlManager. This means keeping the same ID and password combination.
Open <root>\Program Files\Trend Micro\COMMON\TMI\TMI.cfg using a text editor.
Back up TMI.cfg to allow a rollback to the original settings.
Replace the CFG_DM_DB_DSN=Server= parameter value with the name of the destination SQL Server.
Retain the old ID and password. Otherwise, update the values for the following parameters:
CFG_DM_DB_ID
CFG_DM_DB_PWD
Save and close TMI.cfg.
Click Start > Programs > Administrative Tools > Data Sources (ODBC) to open the ODBC Data Source Administrator.
Activate the System DSN tab and then configure the ControlManager_DataBase data source.
On the Microsoft SQL Server DSN Configuration, select the destination server to modify the Which SQL Server do you want to connect to? value and then click Next.
If the destination server is not available from the list, type the server name.
On the next window, select the following:
With SQL Server authentication using a logon ID and password entered by the user
Connect to SQL Server to obtain default settings for the additional configuration
Type the same ID and password available in TMI.cfg and then click Next.
Click Finish to save the new configuration and close Microsoft SQL Server DSN Configuration.
Click OK to close ODBC Data Source Administrator.
Log on to the management console and access the Product Directory to check if all managed products are registered. If so, then you have successfully moved database to the destination SQL Server.