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

Create a technical support case if you need further support.

"Connecting to Admin Database failed…" appears when accessing the InterScan Messaging Security Suite (IMSS) console

    • Updated:
    • 29 Jan 2016
    • Product/Version:
    • InterScan Messaging Security Suite 7.1 Windows
    • Platform:
    • Windows 2003 Enterprise
    • Windows 2003 Standard
    • Windows 2008 Enterprise
    • Windows 2008 Standard
Summary

The following error message appears when you try to access the IMSS web console:

Connecting to Admin Database failed. Please check your DB connection and restart Trend Micro IMSS Web Console

Despite the error, IMSS can still process and route mails.

Details
Public

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.

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