IBM License Metric Tool (ILMT)

 View Only

 Migrated ILMT and Unable to connect to same Bigfix instance

C Powers's profile image
C Powers posted Tue September 16, 2025 05:41 PM

Support - 

We have migrated our ILMT instance from Win 2012 servers to new Win 2022 servers.

We did this via a "lift and shift" of the database to the new set of servers.

We are seeing an issue when attempt to connect to the same Bigfix instance as we had on the old servers.

We are seeing in the log the below error messages:

[9/16/25 21:27:56:198 UTC] 0000002e com.microsoft.sqlserver.jdbc.internals.SQLServerConnection   W ConnectionID:358 ClientConnectionId: bf8e413d-d48f-4a3a-a8e4-010c6aeb4805 Prelogin error: host bigfix.xxx.xxx.xxx port 1433 Error reading prelogin response: Read timed out ClientConnectionId:bf8e413d-d48f-4a3a-a8e4-010c6aeb4805

[9/16/25 21:28:05:857 UTC] 0000002e com.microsoft.sqlserver.jdbc.internals.SQLServerConnection   W ConnectionID:360 ClientConnectionId: 6fb74fb2-3ab7-495b-8096-d762c92a7164 Prelogin error: host bigfix.xxx.xxx.xxx port 1433 Error reading prelogin response: Read timed out ClientConnectionId:6fb74fb2-3ab7-495b-8096-d762c92a7164

[9/16/25 21:28:10:671 UTC] 0000002e com.ibm.ws.webcontainer.webapp                               I SRVE0292I: Servlet Message - [tema]:.[ERROR] RECOMMENDED USER ACTION: Unreachable Database. Check your database name or host connection. It looks like the configuration you have provided is incorrect.

We have confirmed that the ports 52311 and 1433 are open between ILMT and Bigfix.

We have confirmed that port 9081 is open from Bigfix to ILMT.

We have confirmed the service account running ILMT has the proper privileges to Bigfix's database (BFEnterprise)

Looking for any guidance as to what this error message above means and suggestion for resolution?

Oktawian Powązka's profile image
Oktawian Powązka posted Thu September 18, 2025 04:38 AM

That 'Read timed out' seems to be self-explanatory....
Did you try any connection tests on that port (from ILMT server side) or just verified that ports are opened on firewall ?


I'd start with verifying TCP connection between ILMT & SQLServer:
curl -v telnet://<SQLServer>:1433

If the above works you could try the JDBC connection test using SetupDatabase script:
..\LMT\wlp\usr\servers\server1\bin\SetupDatabase.bat -verbose

Upon 'Specify the database host...' please fill in the SQLServer with Bigfix's database.
(On 'Do you want to save a new database connection setup' make sure to answer 'n' not to screw up the current temadb connection setup) .

Related Content