Unable to add Foglight SQL Server agent to monitor SQL Server instance. It failed with exception "Server returned: Connection reset". It also failed with same error message when adding the instance using shortname, FQDN, or IP address. Login is correct and validated locally on the SQL Server. Telnet to port 1433 is allowed and works as well.
The following error message was seen in the DBSS-Installer agent log:
--- On DBSS-Installer-fglamhostname_YYYY-MM-DD_hhmmss_001.log
Traffic signature on the firewall is read with different applications. First it was mssql_base and then its changing to mssql_unencrypted. Both are hosted on port 1433. Make the corresponding adjustment in the firewall to allow both. . Check with internal networking team if additional permissions are required.
For troubleshooting purposes ask to allow all traffic on port 1433 instead of application based rule and create the agent.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center