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 the User should be permitted to access MASTER database. In MASTER database the user Requires VIEW SERVER STATE permission on the server.
Check the Prerequisites for MS SQL Database Server
New to ADSelfService Plus?
Related Articles
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 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 ...Problem occurs while adding DB2 Monitor.
Solution: Check if hostname/IP address is resolving correctly from Applications Manager machine. Check the port is able to telnet from Applications Manager machine. Database name is case sensitive. Kindly verify the same. Make sure that user either ...Problem occurs while adding Informix Monitor.
Solution: Applications Manager uses JDBC to connect to Informix. It will try to connect to sysmaster database in Informix. Make sure that the sysmaster database is present and informix user provided is able to connect to sysmaster database 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 ...