MSSQL
Troubleshooting MS SQL login failure
Problem: The following error message appears in MS SQL monitor during login: "Login Failed. The login is from an untrusted domain and cannot be used with Windows authentication" Solution: Verify if the 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 few database metrics in the Database tab showing empty values in MS SQL monitor?
Why are few database metrics in Database tab showing empty values in MS SQL monitor? Before Applications Manager version 13910, We were showing high-level metrics for MS SQL monitor's Database usage from SQL server performance counters. But from ...
Why are thresholds and alerts not working in Database tab metrics of MS SQL monitor?
In Applications Manager's MS SQL monitor, metrics under Database tab are collected once in an hour by default. Therefore, under Admin -> Performance polling -> MS SQL -> Database Metrics, the option 'Collect SQL Database metrics once in an hour' is ...
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 ...
Problem occurs while adding MS SQL Monitor.
Solution: Check if hostname/IP address is resolving correctly from Applications Manager machine. Check if port is able to telnet from Applications Manager machine. If instance name is provided, check the UDP port(Default: 1434) is reachable. Check ...
Why do I get a java.sql.SQLException: "Unable to get information from SQL Server" when trying to connect to an SQL Server instance?
Reason: The exception you are getting is usually caused by a timeout. When connecting to named instances jTDS needs to connect via UDP to port 1434 to get information about available SQL Server instances. While doing this it times out, throwing the ...