Related to:

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

Problem:

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.

Possible cause(s):

• 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.

Possible solution(s):

• 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.

Related article(s):

• SQL Toolkit 
• OLD DB driver versions
• Geneos 7.x Compatibility Matrix 
• Edit SQLCMD scripts with Query Editor 

If you need further help:

• Please contact our support team via the chat service box on any of our websites or raise a support request.
  
• Make sure you provide us with:
  • Background of the issue or request.
  • Use cases, requirements, business impact, etc.
  • Encountered error messages.
  • Log files or diagnostic files.
  • Screenshots.
  • And other important information relevant to your inquiry.