MSSQL
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 if the Named instance is running in a static or dynamic port Open SQL Server Configuration Manager. Navigate to SQL Server Network Configuration → Protocols for [Instance Name]. Right-click TCP/IP → Properties. Check the IP Addresses ...
Enabling gMSA Account Authentication for SQL Server In Applications Manager
Using a gMSA Account for Applications Manager's SQL Server Backend Important prerequisites before starting the installation: A gMSA account can only be used when Applications Manager is running as a service on Windows platform. To use gMSA account ...
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) ...
How to enable Kerberos Authentication for Applications Manager's MS SQL backend database?
Follow the steps given below to enable Kerberos authentication for MS SQL backend database: 1. Stop Applications Manager service. Open Applications Manager Home directory in command prompt and run the below commands 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
I. How to implement Kerberos Authentication for Applications Manager's MS SQL Back-End Database? 1. Stop Applications Manager service. Open Applications Manager's home directory in the command prompt and run the below commands one by one: For Windows ...
Troubleshooting MS SQL Monitor Addition Problems
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 ...