SQL-Toolkit - Connectivity errors with MS SQL Server 2022 (Login Timeout Expired)

“Login timeout expired” errors ($HYT00$) encountered when using the SQL-Toolkit plugin to monitor MS SQL Server 2022.

Intermittent connection failures while monitoring a SQL Server 2022 setup using a listener name and specific port.

User Interface: The plugin fails to fetch data, likely showing a “Fail” or “Error” status in the Active Console.
Log Files/Backend: The Netprobe logs show the following error: ERROR: SQL-TOOLKIT[...] Fail - HYT00 Login timeout expired(-2147467259) This manifests as a login timeout during the connection handshake.

Root Cause 1: Official support for MS SQL Server 2022 was missing in older Geneos releases.
Root Cause 2: Incorrect or outdated Microsoft OLE DB Driver for SQL Server on the Windows Netprobe host.
Root Cause 3: Connectivity delays inherent in the environment.

Solution Root Cause 1: Upgrade the Geneos components (Netprobe and Gateway) to version GA7.5.0 or later. This version includes official compatibility testing and support for MS SQL Server 2022 as documented in the ITRS Compatibility Matrix.
Solution Root Cause 2: Ensure the Microsoft OLE DB Driver for SQL Server is installed on the Windows Server (2019 or above) hosting the Netprobe. Note that Geneos on Windows uses OLE DB/Native Client rather than the ODBC driver used on Linux.
Solution Root Cause 3: Verify that the Netprobe version matches or exceeds the version suggested. Users should also test connectivity using the sqlcmd utility via the OLE DB provider to isolate whether the timeout is at the OS/Driver level or within the plugin.

Was this topic helpful?