Microsoft SQL
Adding an Azure SQL Database as an MS SQL Monitor
Troubleshooting guide for Azure SQL Database monitoring in ManageEngine Applications Manager. Azure SQL Database has connection and firewall requirements that differ from an on-premises SQL Server. Check the server name, firewall rules and database ...
How to enable the jTDS JDBC Driver option for Microsoft SQL Server monitoring
Steps to enable the jTDS JDBC Driver option The option is controlled by the key am.mssql.hide.driver.option in the AM_GLOBALCONFIG table. Stop Applications Manager. Connect to the Applications Manager database (PostgreSQL / MS SQL back-end) using the ...
How do I resolve certificate validation failures when "Validate Server Certificate" is enabled in the MS SQL monitor?
When Validate Server Certificate is enabled, the MS SQL monitor checks the certificate the SQL Server presents. Three different checks can fail, and each has its own message. Match the message you see, then follow that section. 1. The hostname in the ...
Enabling Kerberos Authentication for SQL Server in Applications Manager
Step ❶ : Register & Verify the SPN An SPN (Service Principal Name) links your SQL Server service to your chosen account. Where to Run Run the following commands on the Domain Controller using a Command Prompt as Administrator. Verify Existing SPN ...
How to generate an MS SQL Self-Help Tool report
Report by selecting the existing host Navigate to Settings → Tools → Self Help Tools → DB Debug. Select "MS SQL" on the "Select Monitor" Drop-down. Select the issue reported, MS SQL, on the "Choose the Host" drop-down. Click Execute. After it got ...
How do I troubleshoot gMSA account issues in Applications Manager?
Applies to: Applications Manager on Windows, connecting to SQL Server with a Group Managed Service Account (gMSA) - as the back-end database at installation time, or as an MS SQL monitor. This guide covers the errors Applications Manager reports when ...
How do I troubleshoot SQL Server Kerberos configuration issues?
Applies to: MS SQL monitors added with Kerberos authentication, and Applications Manager's own MS SQL back-end database when it is configured for Kerberos. When Kerberos authentication is used, Applications Manager obtains a ticket from the domain ...
How do I add an SQL Server named Instance as an MSSQL Monitor?
Applies to: MS SQL monitors added against a named instance, and the error Applications Manager raises when it cannot reach one. A named instance is not reached by host and port alone. Unless the instance listens on a fixed port, the connection first ...
How do I configure a gMSA account for the Applications Manager SQL Server database?
Important prerequisites before installation: A gMSA account can only be used when Applications Manager is running as a service on the Windows platform. To use a gMSA account with SQL Server in Applications Manager, Applications Manager must be ...
How to troubleshoot MS SQL login failure
Applications Manager reached the SQL Server instance, but the server refused the credentials. Two different problems produce a login failure. Match the message you see, then follow that section. Applications Manager shows Authentication failed: ...
Enabling Kerberos Authentication for Applications Manager's MS SQL Backend Database
Follow the steps given below to enable Kerberos authentication for the MS SQL backend database: 1. Stop the Applications Manager service. Open the Applications Manager Home directory in the command prompt and run the commands below one by one. For ...
How is Backup Age calculated for MS SQL DB monitor?
Backup Age represents the number of hours that have elapsed since the most recent backup operation was completed. It is calculated as the difference between the current time and the backup completion time. Backup Age (hours) = Current Time − Backup ...
How do I enable data collection for Cluster Details in the MS SQL Monitor?
The Cluster Details tab is displayed only when the following prerequisites are met: Applications Manager is installed on Windows. (Cluster Details are not supported when Applications Manager is installed on Linux.) A Domain Administrator account (or ...
Why is no data displayed in the Availability Groups table under the AlwaysOn Availability Groups tab of the MS SQL monitor?
This issue typically occurs when the SQL Server user configured for monitoring does not have the required VIEW ANY DEFINITION permission. To verify this, follow the steps below. Step 1: Verify the SQL Server permissions Connect to the ...
Why are some metrics in the Database tab of the MS SQL monitor showing empty values?
Before Applications Manager version 13910, we displayed high-level metrics for the MS SQL monitor’s database usage using SQL Server performance counters. From version 13910 onwards, we fetch detailed database-level metrics. As a result, some metrics ...
Why are thresholds and alerts not working for metrics in the Database tab of the MS SQL monitor?
By default, Applications Manager collects metrics under the Database tab of the MS SQL monitor once every hour. The Collect data control this behavior in every hour option under: Settings → Performance Polling → MS SQL → Metric Name: Database Since ...
How do I resolve the "No Data" issue for MS SQL performance metrics?
Problem: If the metrics in the MS SQL monitor's 'Overview' page aren't getting populated, it might be due to any of the following reasons: MS SQL user does not have permission to access the performance counters. Data collected from SQL Server is not ...
Enabling Kerberos Authentication for SQL Server in Applications Manager
Kerberos Authentication Setup for MS SQL Monitor Applications Manager Configuration Guide Table of Contents Step 1: Register & Verify the SPN Step 2: Generate & Verify the Keytab File Step 3: Configure the login.conf File Step 4: Configure ...
How can I execute an MS SQLDebug.bat / MsSQLDebug.sh file?
The MsSQLDebug file is a diagnostic tool used to verify connectivity and discoverability of the MS SQL Server from the Applications Manager server. This standalone utility replicates the internal process used when adding an MS SQL Server monitor. ...
Troubleshooting issues while adding an MS SQL Monitor
Work through the checks below to resolve the errors most often seen when adding a Microsoft SQL Server monitor in Applications Manager. Each section names the error message it applies to. If the monitor reports a rejected login — Login failed for ...