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

Create a technical support case if you need further support.

Error messages when logging in to the Control Manager (TMCM) console

    • Updated:
    • 12 Oct 2016
    • Product/Version:
    • Control Manager 6.0
    • Platform:
    • Windows 2003 Compute Cluster Server
    • Windows 2003 Datacenter Server
    • Windows 2003 Datacenter Server Edition 64-bit
    • Windows 2003 Enterprise Server
    • Windows 2003 Standard Server Edition
    • Windows 2003 Standard Server Edition 64-bit
    • Windows 2003 Storage Server
    • Windows 2008 Datacenter Server
    • Windows 2008 Enterprise Server
    • Windows 2008 Standard Server Edition
Summary

The following error message appears when logging in to the TMCM console:

  • For TMCM 5.5 and below:

    Please type your username and password to access the product console.
    Cannot logon. Database operation is unsuccessful. Please verify database service is started and try again.

  • For TMCM 6.0:

    Unsuccessful database operation. Please check the database status and try again.

    Unsuccessful database operation

Details
Public

This issue occurs due to the following:

Scenario 1: TMCM server is pointed to a different SQL server after upgrading

To resolve this issue, change the Control Manager (TMCM) database configuration settings.

Scenario 2: SQL Authentication account information has been modified

To resolve this issue:

  1. Make sure that the following TMCM and SQL services are running:
    • Trend Micro Common CGI
    • Trend Micro Control Manager
    • Trend Micro Management Infrastructure
    • SQL Server
    • SQL Server VSS Writer
  2. In SQL Authentication, check if the account information has been modified (e.g username or password being used by TMCM).

    You can also use the ODBC settings to verify the TMCM connection to the SQL server.

  3. If the account has been modified, use the DBconfig tool to reflect the changes in the TMCM settings.

Scenario 3: Passwords with the characters > < “ are blocked by Java

Java limits the characters > < " when used as password during installation or for existing SQL servers.

You will not be able to log in after installing TMCM if you use one of the characters above as SQL administrator account password. TMCM is unable to properly pull the data from the SQL server because the characters used are not accepted.

Running the command “'dbconfig -DBName="db_controlmanager" -DBAccount="tmcm" -DBPassword="<testpw"" - mode="SQL” will result in the following error message:

Invalid authorization specification, please enter correct database account and password.

Invalid authorization specification

To resolve this, it is recommended to change your password and avoid using passwords with the three characters > < " when installing TMCM 6.0 or for existing SQL servers.

Premium
Internal
Rating:
Category:
Upgrade
Solution Id:
1053585
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.