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

Create a technical support case if you need further support.

Changing the Control Manager (TMCM) database configuration settings

    • Updated:
    • 3 Oct 2016
    • Product/Version:
    • Control Manager 6.0
    • Platform:
    • Windows 2003 Enterprise Server
    • Windows 2003 Standard Server Edition
    • Windows 2008 Enterprise
    • Windows 2008 Standard
Summary

This entry applies to the following:

  • Moving the TMCM database from one Microsoft SQL server to another.
  • Importing a TMCM database to the SQL server and configuring TMCM to use the new database.
  • Changing the TMCM database name.
  • Changing the username and/or password of the account that the TMCM server uses.
Details
Public

Do the following:

  1. Configure TMCM to use a different database.
    This includes the following:
    • Using the same database, but on a different SQL server
    • Using a different database on the same SQL server
    • Using a different database on a different SQL server

    1. If you are moving the TMCM database to another SQL server, then follow the steps in this article:

      Moving databases between computers that are running SQL Server

    2. Set an account to be part of the DBO scheme for the TMCM database.

      It is possible that while moving to another server, the account associated with DBO is no longer available.

      Make sure to set the following permissions:

      • Mixed-mode and Windows authentication
      • The SQL account assigned for TMCM should have:
        • dbcreator permission for the server role is needed during installation
        • Db_owner permission and DBO user account for the database role to the db_controlmanager database
    3. Make sure that the latest TMCM patch is installed.
    4. Open a command prompt.
    5. Change the directory to the ..\Control Manager\Dbconfig folder.
    6. Run the Dbconfig.exe tool.

      Usage: DBConfig [options]

      Use this tool to modify the database settings.

      Options:

      • DBName="database name" database name.
      • DBAccount="database account" database account.
      • DBPassword="database password" database password.
      • Mode="SQL" authentication mode. SQL or WA.
      • DBHost="ip address/hostname" database ip address/hostname.
      • Owner change owner to dbo.

        Example:

        DBConfig -DBName="db" -DBAccount="sqlAct" -DBPassword="sqlPwd" -Mode="SQL" -DBHost="10.1.152.124"

        Example:

        DBConfig -DBName="db" -DBAccount="winAct" -DBPassword="winPwd" -Mode="WA" -DBHost="(local)"

        Example:

        DBConfig -DBName="db" -DBAccount="sqlAct" -DBPassword="sqlPwd" -Mode="SQL" -DBHost="(local)\SQLEXPRESS"

        Example:

        DBConfig -Owner

       
      • Default Mode is the SQL authentication mode. Mode="WA" is necessary when configuring for Windows authentication.
      • TMCM 3.5 only has SQL authentication.
      • Windows account must belong to Administrators group.
  2. Change the username and/or password of the account that TMCM uses to access the database.
  1. Set a DBO account for the TMCM database.
  2. If you will use a new account, and will use "Windows Authentication" for SQL Login, make sure that the Windows account is a member of the built-in Local Administrators group. "Log on as a Service" and "Log on as a Batch Job" user rights are also needed. These are set in Step 3.
  3. Use the DBConfig tool to configure the new username and password.

    Example:

    DBConfig -DBName="db" -DBAccount="sqlAct" -DBPassword="sqlPwd" -Mode="SQL"

     
    • This action/step will change the connection strings in ASP.net to local.
    • Make sure to specify the DBO account associated with the database when using the DBConfig tool.
    • The DBConfig tool is case-sensitive. Make sure to follow the parameter and values exactly.
    • Make sure that DBName is specified as DBName, not "dbname". Also, if the database name on the SQL server is db_ControlManager, it should be specified as db_ControlManager, not "db_controlmanager".
Premium
Internal
Rating:
Category:
Configure
Solution Id:
1037887
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.


Need More Help?

Create a technical support case if you need further support.