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 after applying Patch 3 on InterScan Messaging Security Suite (IMSS) 7.1

    • Updated:
    • 10 Mar 2014
    • Product/Version:
    • InterScan Messaging Security Suite 7.1 Windows
    • Platform:
    • Windows 2000 Advanced Server
    • Windows 2000 Server
    • Windows 2003 Enterprise
    • Windows 2003 Standard
    • Windows 2008 Enterprise
    • Windows 2008 Standard
Summary
After you apply Patch 3 or Hot fix 1504 on IMSS 7.1 Windows using SQL Server 2000 SP4 (or MSDE 2000) as database, IMSS fails to connect to the database. You also encounter the following error message when logging in to the web console:
Connecting to Admin Database failed. Please check your DB connection and restart Trend Micro IMSS Web Console.
Details
Public
The issue occurs because IMSS 7.1 for Windows Patch 3 contains a new JDBC driver. The old driver replaces the new one which does not support SQL 2000.
The patch supports the following platforms:
  • Microsoft SQL Server 2008
  • SQL Server 2008 R2
  • SQL Server 2008 Service Pack 3
  • SQL Server 2008 R2 Service Pack 1
  • SQL Server 2008 R2 Service Pack 2
IMSS backs up all files replaced by a hot fix or patch under the temp folder of the IMSS root folder. For example, C:\Program Files\Trend Micro\IMSS\temp\14850\backup stores files replaced by Patch 2 Build 14850.
As a workaround, do the following:
  1. Stop the IMSS services.
  2. Back up the sqljdbc.jar file located at {IMSS_installation_folder}\ui\adminUI\webapps\ROOT\WEB-INF\lib\.
    By default, the IMSS installation folder is C:\Program Files\Trend Micro\IMSS\.
  3. Replace the sqljdbc.jar on the {IMSS_Backup_folder}\ui\adminUI\webapps\ROOT\WEB-INF\lib\ folder.
    By default the backup folder for Patch 3 is C:\Program Files\Trend Micro\IMSS\temp\15240\backup and the backup folder for hot fix B1504 is C:\Program Files\Trend Micro\IMSS\temp\15040\backup\.
  4. Restart the IMSS services.
    Note: Microsoft has ended support for SQL2000/MSDE2000. We recommend that you upgrade your database server to SQL 2005 or SQL 2008.
Premium
Internal
Rating:
Category:
Troubleshoot; Deploy; Install
Solution Id:
1099290
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.