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.