Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

Moving the Control Manager database from SQL Express to SQL (Full version)

    • Updated:
    • 23 Aug 2018
    • Product/Version:
    • Control Manager 7.0
    • Platform:
    • Windows 2008 Server R2
    • Windows 2008 Standard
    • Windows 2008 Standard 64-bit
    • Windows 2012 Server
    • Windows 2012 Server R2
    • Windows 2012 Standard R2
    • Windows 2016
    • Windows 2016 Server
    • Windows 2016 Standard
Summary
In this article you will find the steps how to move the Control Manager Database from the SQL Server Express to a SQL Server Standard or SQL Server Enterprise. 
Details
Public
  1. Install Microsoft SQL Server Management Studio.
  2. Stop the following Control Manager Services:
    • Trend Micro Control Manager
    • Trend Micro Management Infrastructure
    • Trend Micro Common CGI
  3. Open Microsoft SQL Server Management Studio and connect to the SQL Express Instance.

    SQL Express login

  4. Right click on "db_ControlManager" (it can differ if you chose a different name)
  5. Click on Tasks > Detach.

    Object Explorer

  6. Tick Drop Connections and Update Statistics. All existing Connections will be dropped.

    Detach Database

  7. Copy the following database files to the new SQL Server:
    • db_ControlManager.mdf
    • db_ControlManager_log.ldf

    The default file location of the SQL Server is \Program Files\ Microsoft SQL Server\MSSQL<Version>.<InstanceID>\MSSQL\DATA

  8. Open Microsoft SQL Server Management Studio and connect to the new SQL Server Instance.
  9. On the left pane, right-click on Databases, then select Attach...

    Attach database

  10. Click on Add.

    Attach DB - Add

  11. Choose which Database you want to attach.

    Attach DB - Select DB

  12. Once the Database is successfully attached, configure TMCM to connect to the new Database. Do the following:
    1. Go to the TMCM Server and open Command Prompt.
    2. Navigate to C:\Program Files (x86)\Trend Micro\Control Manager\DBConfig.
    3. Use the following command:
      DBConfig.exe -DBName="<DBname>" -DBAccount="<DBaccount>" -DBPassword="<password>" -Mode=">WA or SQL>" -DBHost="<IP address or FQDN of SQL server>"

      Where:

      • DBName - Name of the Database
      • DBAccount - Account used to login on the SQL Server Management Studio to access the DB
      • DBPassword - Password used to login on the SQL Server Management Studio to access the DB
      • Mode - There are 2 options WA (Windows Authentication) or SQL
      • DBHost - Use the IP or FQDN of your SQL Server

    Below is an example of a successful connection to the database:

    Successful Connection

Premium
Internal
Rating:
Category:
Deploy; Migrate
Solution Id:
1120629
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.