You may encounter the following problems when installing TMCM/Apex Central™ 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.
To resolve this issue, make sure that the language of the SQL account used by TMCM/Apex Central™ is English.
For example, the German SQL can be configured by doing the following:
- Open the SQL Management Studio.
- Go to Security > Logins.
- Right-click the SQL account used by TMCM to log in, then click Properties.
- In the General tab, set the Default Language to English.
- Click OK.
- Restart the TMCM Service and Trend Micro Management Infrastructure Service.