This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

how to setup alert for SQL server

sajiimi over 4 years ago

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.

Top Replies

0 ralfs over 4 years ago

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?
Cancel
Vote Up 0 Vote Down

Cancel
0 adam.beedell over 4 years ago

"Error Locating Server/Instance Specified"
My money's on either the "SQL Server Instance" or "Initial Catalog" values on the template being wrong
Cancel
Vote Up +1 Vote Down

Cancel
0 jhandberg over 4 years ago
I monitor several SQL instances with SAM and AppInsight for SQL. There are a couple of possibilities.
The instance may or may not be on the default SQL port of 1433. If an SQL server holds multiple databases, then they will all be on different ports, even if one of the instances is on the default port.
To monitor with SAM, you need a username and password for the database instance, not just the node.
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.
Cancel
Vote Up 0 Vote Down

Cancel
0 sajiimi over 4 years ago in reply to ralfs

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.
Cancel
Vote Up 0 Vote Down

Cancel
0 sajiimi over 4 years ago in reply to adam.beedell

Thanks Adam for taking time and looking into. and catalog master.
I have created new monitor under
Application Monitor Name: xxx
Cancel
Vote Up 0 Vote Down

Cancel
0 adam.beedell over 4 years ago in reply to sajiimi

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"
Cancel
Vote Up 0 Vote Down

Cancel
0 sajiimi over 4 years ago in reply to adam.beedell

database is master ( on screen shot as well).
Appinsight working but why the newly created template not working.
Cancel
Vote Up 0 Vote Down

Cancel
0 ralfs over 4 years ago in reply to sajiimi

please try 'select 1' as query
Cancel
Vote Up +1 Vote Down

Cancel
0 bobmarley over 4 years ago

You need to have an actual query here
Select something from something
Cancel
Vote Up 0 Vote Down

Cancel
0 Seashore over 4 years ago in reply to sajiimi

USE [databasename] is not allowed there.
Just try a simple "select 1" instead as someone said, but the USE-command is not allowed.
Cancel
Vote Up 0 Vote Down

Cancel