When tryting to add new SQL Server to monitor, the error below occurs and Foglight fails to create a new DBSS agent.
Database Connection Failed
Failed to monitor SERVERNAME
Error: [Foglight][SQLServer JDBC Driver]Object has been closed.
Failed to establish a SQL-Server JDBC connection protocol to Host [HOSTNAME\DeFAULT_INSTANCE], user
account [DOMAIN\user]. Reason : [[Foglight][SQLServer JDBC Driver]Object has been closed.-
Profile:MSSQLProfile{host='HOSTNAME',
instance= 'DEFAULT_INSTANCE',
username='DOMAIN\user', authType= 'windows_custom', port= '0' useNTLMv2= 'true',
socketTimeout= '900', secureConnection= 'REQUEST' }]. . [SQL-Server Error Code = 0. SQL state : HY000]