10 Replies Latest reply on Aug 19, 2019 9:36 AM by Seashore

    how to setup alert for SQL server

    sajiimi

      how to setup an alert against SQL server query.

       

      I have tired creating alert using "SAM Setting" - > application monitor

       

      but getting error "TEST failed with "DOWN" status on "hostname".

       

      A network-related or instance-specific error occurred while
      establishing a connection to SQL Server. The server was not found or was not
      accessible. Verify that the instance name is correct and that SQL Server is
      configured to allow remote connections. (provider: SQL Network Interfaces,
      error: 26 - Error Locating Server/Instance Specified)

       

       

      SAME time I can able to connect SQL server through "AppInsight for SQL".

       

      Can you guide me how to fix this ?

       

      Is that SQL Servers can't be monitor without Database Performance Analyzer (DPA) ? we don't have DPA.

       

      Appreciate your help.