Foglight agent failed to connect to an Azure SQL Database using AAD Password authentication. The error observed:
javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
Despite the connection string including enforceSSLVersion='NONE', SSL was still attempted and failed.
A few minutes later the connection was reestablished automatically. No changes were made to TLS settings, truststore, or Foglight configuration.
dbConnectAvaliability changed from true to false
1-5 minutes later (based on collection frequencies)
dbConnectAvaliability changed from false to true
The Azure SQL usability connection auto-retries connections every 60 seconds (online and realtime modes) or 300 seconds (offline mode). For a temporary connection issue due to transient Azure or network issue resolving it is likely to see the connection reestablished after a few minutes.
If this continues to happen often, add -Djavax.net.debug=ssl to baseline.jvmargs.config to trace handshake behavior and confirm retry success.
For recurring issues, consider reviewing network stability, proxy behavior, and enabling debug agent logging to capture transient fault patterns.