Microsoft SQL
How do I resolve certificate validation failures when "Validate Server Certificate" is enabled in the MS SQL monitor?
Issue When Validate Server Certificate is enabled, the MS SQL monitor may fail with the following error: MS SQL : Certificate validation failed. The hostname in the SQL Server's certificate does not match the configured hostname. Please ensure 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?
This guide provides step-by-step instructions to resolve authentication issues when using a Group Managed Service Account (gMSA) with ManageEngine Applications Manager for SQL Server connectivity. Troubleshooting during Installation If authentication ...
How do I troubleshoot SQL Server Kerberos configuration issues?
Step 1: Verify the Kerberos configuration in Applications Manager Ensure that Kerberos authentication has been configured correctly in Applications Manager by following the steps in the relevant KB article. Step 2: Verify the hostname and domain ...
How do I add an SQL Server named Instance as an MSSQL Monitor?
Step 1: Determine whether the named instance is using a static or dynamic TCP port Open SQL Server Configuration Manager. Navigate to: SQL Server Network Configuration → Protocols for [Instance Name]. Right-click TCP/IP and select Properties. Open ...
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
Login Failed. The login is from an untrusted domain and cannot be used with Windows authentication. Follow the steps given below to resolve this error. 1. Verify Credentials Ensure that the username and password of the SQL account (domain\username) ...
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
1. Ensure that the SQL Server is running and accessible. Try connecting to the SQL Server instance via SQL Server Management Studio or DBVisualizer using the same credentials. This step helps diagnose connection issues, ensuring that both the server ...