Unable to add Foglight SQL Server agent to monitor SQL Server instance. It failed with exception "Login has timed out". It also failed with same error message when adding the instance using shortname, FQDN, or IP address.
The following error message was seen in the DBSS-Installer agent log:
ERROR [FglAM:IncomingMessage[5]-50] com.quest.qsi.fason.sqlserver.installer.validation.DBSSDbValidator - Validation failed: cannot establish a DB connection to host testing.prod.corp.com with profile MSSQLProfile{host='testing.prod.corp.com', instance= 'TEST', username='AD\foglight', authType= 'WINDOWS_CUSTOM', port= '8000' useNTLMv2= 'true', socketTimeout= '900', secureConnection= 'OFF' }
com.quest.qsi.fason.framework.connections.common.exceptions.FrameworkException: Failed to establish a SQL-Server JDBC connection protocol to Host [testing.prod.corp.com\TEST], user account [AD\foglight] . Reason : [[Foglight][SQLServer JDBC Driver]Login has timed out.- Profile:MSSQLProfile{host='testing.prod.corp.com', instance= 'TEST', username='AD\foglight', authType= 'WINDOWS_CUSTOM', port= '8000' useNTLMv2= 'true', socketTimeout= '900', secureConnection= 'OFF' }]. . [SQL-Server Error Code = 0. SQL state : HYT00]
