Microsoft SQL
MS SQL Monitor — Certificate Validation Failure When Validate Server Certificate is Enabled
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 Servers 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 MS SQL Self-Help Tool report
Steps to generate MS SQL Self-Help tool report: Report by selecting 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" ...
gMSA troubleshooting steps
Troubleshooting Guide for 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 ...
SQL Server Kerberos Configuration Troubleshooting Guide
Step 1: Verify Kerberos Configuration in AppManager Step 2: Check Hostname and Domain Step 3: Verify Service Principal Name (SPN) Configuration Step 4: Check krb5.ini Configuration Step 5: Ensure System Clock Synchronization Step 6: Check Ticket ...
How to add a SQL Server Named Instance as an MSSQL Monitor?
Step 1: Check 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. Go to the IP ...
Configuring a gMSA Account for Applications Manager's 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 ...
Troubleshooting 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 the 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 displays the number of hours passed since the backup operation was completed. In simple terms, it is the difference between the current time and the time at which backup was performed. Backup Age (hours) = Current Time - Backup Time By ...
Enabling data collection for Cluster Details in MS SQL Monitor
If you have installed Applications Manager in Linux, Cluster Tab details won't be available. Domain Administrator account (with privileges to execute WMI queries) is required for cluster monitoring. To view cluster details, you must have provided ...
No data available in 'Availability Groups' table under 'AlwaysOn Availability Groups' tab in MS SQL monitor
Solution: Check whether 'VIEW ANY DEFINITION' permission is given to monitor AlwaysOn Availability Groups. To do so, follow the steps given below: Connect AlwaysOn enabled server in SQL Server Management Studio with the username which is used to ...
Why are a few database metrics in the Database tab showing empty values in the MS SQL monitor?
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 in Database tab metrics of MS SQL monitor?
In Applications Manager's MS SQL monitor, metrics under the Database tab are collected once every hour by default. This is controlled by the 'Collect data in every hour' option under Settings → Performance Polling → MS SQL → Metric Name: Database, ...
Resolving no data error for MSSQL performance metrics
Problem: If the metrics in the MS SQL monitor's 'Overview' page isn't getting populated, it might be due to any of the following reasons: - MSSQL user does not have permission to access the performance counters. - Data collected from SQL server is ...
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 a 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 ...
