SQL Server agent doesn't collect data with "Login failed" error and "SQL-Server Error Code = 18456. SQL state : 28000" (4296073)

One of the SQLServer agents doesn't collect data. 

The DBSS agent log displays an exception similar to the following: 

AgentConnectionException:Failed to establish a SQL-Server JDBC connection protocol to Host [server1.mycompany.com\DEFAULT_INSTANCE], user account [foglight] . Reason : [[DataDirect][SQLServer JDBC Driver][SQLServer]Login failed for user 'foglight'.- Profile:MSSQLProfile{host='server1.mycompany.com', instance= 'DEFAULT_INSTANCE', username='foglight', authType= 'SQL_SERVER', port= '1433' useNTLMv2= 'false', socketTimeout= '900', secureConnection= 'REQUEST' }]. . [SQL-Server Error Code = 18456. SQL state : 28000]

The database logon account supplied is in error or cannot be processed by the security providor:

• The Windows login is restricted either by exclusion or inheritance(group or policy), or role association
• The Windows login is not added to the SQL Server
• The Windows Login is disabled.
• The login Username is incorrect (type, missing domain)
• The login Password is incorrect (typo, expired, length)
• lnstance name is incorrect (check for multiple instances on same host)
• Domain Trust missing
• NTLM version mismatch
• Firewall restriction or network communication issue  (DMZ, hosted environment, geolocated datacenters)