Unable to add SQL insight monitor
If the SQL Insight monitor is not getting added even after entering your credentials, try these troubleshooting steps:
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)
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.
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.
Also, ensure that the credentials given are valid and that you're able to log in to your SQL instance with the same credentials.
Related Articles
I can only see a limited amount of MySQL database monitors added. How to add new databases for monitoring?
By default, MySQL instances will be auto-discovered and added as free monitors. MySQL data collection and monitoring will start once the agent is provided with the proper credentials. Check this article on how to add or update credentials. New ...I have an SQL Cluster that is Up and running. But the Insight monitor is indicating Down.
If the SQL Cluster Insight monitor is indicating DOWN even after giving credentials, check the following cases: Please check if you have given credentials in both the active and passive nodes. If the credentials have been updated only in the passive ...How is MySQL added for monitoring in Site24x7?
Site24x7 uses the server monitoring agent to monitor MySQL databases. To install the Site24x7 Server monitoring agent, follow the below steps: Log in to Site24x7. Install the Linux Server monitoring agent by navigating to Server > Server Monitor > ...APM Insight provides information on the parameters it sends to the SQL queries
The parameters in slow SQL queries can be tracked and displayed under the traces tab. We have the option to obfuscate the values of SQL query parameters using a configuration "Obfuscate SQL Parameters". It will be enabled by default. The screenshot ...Export SQL database details
Please follow the below steps to fetch individual database reports from SQL servers: Log in to Site24x7. Navigate to Server > Microsoft SQL Server > click on the SQL server from which you want to export data. Go to Database, and scroll down to ...