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

Create a technical support case if you need further support.

Issues encountered when installing Control Manager (TMCM) 7.0 with a non-English SQL server

    • Updated:
    • 6 Dec 2017
    • Product/Version:
    • Control Manager 7.0
    • Platform:
    • Windows 2008 Server R2
    • Windows 2008 Standard
    • Windows 2008 Standard 64-bit
    • Windows 2012 Enterprise
    • Windows 2012 Standard R2
    • Windows 2016
Summary

You may encounter the following problems when installing the TMCM 7.0 with a non-English SQL server:

  • The Operation Center is continuously loading and unable to respond.

    From UI_Debug.log, in the <CM Root>\Debuglog folder, the following error is displayed and the SQL Language is in German:

    ERROR - __ExeDashboard__: ExeDashboardDatabaseUtility.QueryReportingLineMap: SQL Exception(no:8114) : System.Data.SqlClient.SqlException (0x80131904): Fehler beim Konvertieren des nvarchar-Datentyps in datetime.
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1
    wrapCloseInAction)
    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection,
    Action`1 wrapCloseInAction)

  • Unable to generate the static report.

    From TMCM_CSharpReportViewer.log, in the <CM Root>\DebugLog folder, the following error is displayed and the SQL Language is in French:

    FATAL - System.Data.SqlClient.SqlException (0x80131904): Erreur de conversion du type de données nvarchar en datetime.
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1
    wrapCloseInAction)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean
    callerHasConnectionLock, Boolean asyncClose)

  • When you open the User/Endpoint menu, you may be logged-out automatically.
Details
Public

To resolve this issue, make sure that the language of the SQL account used by TMCM is English.

For example, the German SQL can be configured by doing the following:

  1. Open the SQL Management Studio.
  2. Go to Security > Logins.
  3. Right-click the SQL account used by TMCM to log in, then click Properties.
  4. In the General tab, set the Default Language to English.
  5. Click OK.
  6. Restart the TMCM Service and Trend Micro Management Infrastructure Service.
 
For other languages, the settings should be adjusted accordingly.
Premium
Internal
Rating:
Category:
Troubleshoot
Solution Id:
1118889
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.