-
Title
Causes for "Login has timed out" (SQL state : HYT00) errors when adding a new SQL Server agent -
Description
The following error is encountered during the creation of a SQL Server agent in Foglight
Failed to establish a SQL-Server JDBC connection protocol to Host [\DEFAULT_INSTANCE], user account [foglight] . Reason : [[Foglight][SQLServer JDBC Driver]Login has timed out.- Profile:MSSQLProfile{host='', instance= 'DEFAULT_INSTANCE', username='foglight', authType= 'SQL_SERVER', port= '50000' useNTLMv2= 'false', socketTimeout= '900', secureConnection= 'OFF' }]. . [SQL-Server Error Code = 0. SQL state : HYT00]. -
Cause
Cause 1
User/password is invalid causing user not able to connect to SQL Server
Cause 2
Networking issues
Cause 3
The remote host is down or unavailable
-
Resolution
Resolution 1
Check user/password combination in SQL Server Management Studio and ensure user is able access to SQL Server, user is not locked or password expired.
Resolution 2
Check if there are any networking issues such as a firewall blocking the port that may be limiting the connection from the Foglight Agent Manager to the remote host (KB 231918).
The Foglight user or the FglAM process may need to be added to the firewall allow list (i.e. in IPTABLES)
Resolution 3
Confirm that the monitored host server is active and running.