Views:

To resolve this issue, modify the parameters in several IMSS files.

  1. Check the value of the "InstalledInstances" key.
    1. Open the Registry Editor.
       
      Always back up the whole registry before making any modifications. Incorrect changes to the registry can cause serious system problems.
    2. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server.
    3. Check and take note of the value of the "InstalledInstances" key (e.g. IMSS_SSEINSTACE or SQLEXPRESS).
  2. Verify the value of Microsoft SQL Server DSN Configuration.
    1. Go to Administrative Tools > Data Sources (ODBC).
    2. Go to System DSN and then click Configure on IMSSServer.
    3. Check if the value of the server parameter is similar to the value found in the registry. The format should be:

      ip address\[value of the InstalledInstances]

      e.g. xxx.xxx.xxx.xxx\IMSS_SSEINSTACE or xxx.xxx.xxx.xxx\SQLEXPRESS

    4. Test if the supplied information will allow successful completion of the test database connection after providing the appropriate credentials to the database. Click Test Data Source.
  3. Modify the parameter for [odbc.ini].
    1. Go to the ..Program Files\Trend Micro\IMSS\config folder.
    2. Create a backup of the odbc.ini file.
    3. Edit the odbc.ini file and modify the "Servername=" parameter.

      ip address\[value of the InstalledInstances] (e.g. xxx.xxx.xxx.xxx\SQLEXPRESS)

    4. Save and close the file.
  4. Modify the parameter for the struts-config-common.xml file.
    1. Go to the ..\Program Files\Trend Micro\IMSS\ui\adminUI\webapps\ROOT\WEB-INF folder.
    2. Create a backup of the struts-config-common.xml file.
    3. Edit the struts-config-common.xml file.
    4. Look for the string similar to the following:

      set-property
      property=<url>

    5. Change the setting to:

      value="jdbc:sqlserver://<IP of the new SQL server instance>;DatabaseName=imss"/

       
      If you use another port for the SQL server, you can change the above to:
      set-property property=<url> value="jdbc:sqlserver://;DatabaseName=imss"/ take note of the colon (:) between the and the value of the new SQL server IP and new port.
    6. Save and close the file.
  5. Restart the Trend Micro IMSS Web Console service.
  6. Access the IMSS web console.

If the issue still persists or if you encountered errors with the procedure, run the CDT utility, collect the logs, and contact Trend Micro Technical Support for further assistance.