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
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:
- Stop the IMSS services.
- 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\.
- 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\.
- 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.