Unable to add SQL insight monitor

Unable to add SQL insight monitor

If the SQL Insight monitor is not getting added even after entering your credentials, try these troubleshooting steps:

  1. Ensure that the Auto-discover applications feature is enabled. If not, you will need to trigger discovery using the Discover Applications tab from the corresponding server monitor after giving your credentials. (Server > Server Monitors > Servers > Click the desired monitor > Click the hamburger icon  beside the monitor name > Discover Applications)


  1. If you have an SQL cluster setup, you need to give the credentials in both the active and passive nodes, as both the nodes will point to a single Insight monitor in the Site24x7 web console.

  1. Check if FIPS has been enabled in the machine by checking the below registry key:

     HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Lsa\FipsAlgorithmPolicy\Enabled

    If FIPS has been enabled, kindly contact our support team for assistance.

  1. Also, ensure that the credentials given are valid and that you're able to log in to your SQL instance with the same credentials.

If you still face issues in adding the monitor, please zip the entire <agent installation dir>\monitoring folder and send it to support@site24x7.com.
    • Related Articles

    • How do I monitor an Oracle database hosted in a Docker container in the same machine?

      To monitor your Oracle Database hosted in a Docker container, follow these steps: Log in to Site24x7 and install the Site24x7 Linux monitoring agent. Execute the following command in your terminal and enter your Oracle Database instance's username ...
    • Troubleshooting false positive alerts in monitoring

      Problem False positive alerts are being generated. Possible cause The monitoring system is down in some locations. The Website monitor might be configured for one location, such as Seattle, but may appear down when accessed from another location, ...
    • Monitor database issues for OpenCart or Joomla websites

      Database issues for websites developed using OpenCart or Joomla can be identified by enabling a Content Match. Configure your website response such that a particular text is always present during all success responses and absent during all error ...
    • Difference between a website monitor and a SOAP Web Service monitor

      Website monitor will support monitoring of any web application via POST, GET and HEAD methods of configuration. Learn more on the performance metrics provided for a website monitor. SOAP Web Service monitors , on the other hand, lets you to ...
    • Exclude Site24x7 monitoring traffic from Google Analytics

      You can exclude traffic from the Site24x7 Web Transaction (Browser) monitor and Webpage Speed (Browser) traffic from Google Analytics in two ways. To exclude traffic for the Web Defacement monitor, you can follow the first method. 1. Creating a ...