How To Migrate The Trend Micro Control Manager Database

IT Support Forum Forums Antivirus Trend Micro Control Manager Installation How To Migrate The Trend Micro Control Manager Database

Tagged: 

This topic contains 5 replies, has 3 voices, and was last updated by  cw72 2 years, 8 months ago.

  • Author
    Posts
  • #288

    Webmaster
    Keymaster

    If you’re decomissioning a SQL server, you might need to migrate the Trend Micro Control Manager database (db_ControlManager). To migrate the Trend Micro Control Manager database:

    1. Log onto the Trend Micro Control Manager server
    2. The database settings are actually stored in C:\Program Files (x86)\Trend Micro\COMMON\TMI, under the CFG_DM_DB_DSN setting. By default, this will point to a System DSN called ControlManager_Database. You don’t need to change the TMI.cfg file
    3. Click Start -> Control Panel -> Administrator Tools and launch Data Sources (ODBC)
    4. Click on the System DSN tab
    5. Select the ControlManager_Database DSN
    6. Click Configure…
    7. This will tell you where your Trend Micro Control Manager database is currently stored
    8. Stop the Trend Micro Control Manager services on the server
    9. Navigate to the SQL server and take a copy of the SQL database (either by backing it up or detaching it and copying the files)
    10. Navigate to the SQL server that you wish to migrate the Trend Micro Control Manager database to and restore or attach the database, depending on the copy method you used in the previous step
    11. Go back to the ODBC configuration on the Trend Micro Control Manager server
    12. Change the Server to the SQL server instance that you migrated the Trend Micro Control Manager database to
    13. Start the Trend Micro Control Manager services that you stopped
    14. Log onto the Trend Micro Control Manager website to make sure that everything is working and that the database has been successfully migrated

  • #289

    Webmaster
    Keymaster

    If your TMI.cfg file specifies:

    CFG_DM_DB_DSN=Server=< >

    Then you need to change the parameter to the name of the new SQL server as well.

  • #290

    Webmaster
    Keymaster

    It’s also best practice to run the Database Upgrade Adviser against the database you are migrating, if moving to a different version of SQL.

  • #495

    McLovin
    Participant

    When I run the SQL 2008 R2 Upgrade Advisor prior to migrating the Trend Micro Control Manager database, I get Column Aliases In ORDER BY Claus Cannot Be Prefixed By Table Alias.

    Is it safe to continue migrating the database with this error?

  • #499

    Webmaster
    Keymaster

    In that case, you can’t migrate the Trend Micro Control Manager database using the above method. According to Trend Micro Support, you need to do the following:

    1. Backup Trend Micro Control Manager
    2. Uninstall Trend Micro Control Manager
    3. Restore Trend Micro Control Manager
  • #1058

    cw72
    Participant

    thank you

You must be logged in to reply to this topic.