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.
May we have a little bit more details? When I see the error message you may double check the server or instance name which you are using I would compare what'S configured in Appinsight with the what you have configured for that test. BTW: which template are you using for that test?
Thanks for taking time looking into.
I am using application monitor and using same host name as Appinsight.
In Appinsight, it was successfully able to test connection but newly created "monitor" under application monitor not able to connect.
"Error Locating Server/Instance Specified"
My money's on either the "SQL Server Instance" or "Initial Catalog" values on the template being wrong
Without knowing the database you're trying to connect to it's difficult to say more - Your DBAs should be able to see if the connection is making it to the DB and if there's an error on the other end.
I have a monitor very similar to the above, and I've had similar problems, for that error it's usually a targeting problem, and the DBAs have been able to assist.
Ultimately the error is saying "I cant find what you wanted me to find, where you sent me to find it"
I monitor several SQL instances with SAM and AppInsight for SQL. There are a couple of possibilities.
This can get a bit more complex if the SQL instance is in a cluster. Then I usually monitor the database against the cluster VIP, which is usually different than the server IP.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.