Problem occurs while adding MS SQL Monitor.

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.


If issue still persists, execute the file MsSQLDebug.bat under <AppManager-Home>\bin\troubleshooting and send the result.
      • 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) ...
      • 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 ...
      • 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. Only Windows Admistrative users will be able to view Cluster Details tab in MS SQL Monitor. To view cluster details, you must have provided Windows ...