Verify failed SQL Server connections to instances on a given server and email them
1
vote
2
answers
143
views
I am trying to monitor the SQL Server instances on standalone server / cluster server. I would like to setup something from commandline to check for connectivity to each SQL Server instance on the server. Wherever it fails to connect to an instance I would like to have an email (we have smtp server setup) sent to our DBA team.
Each server is having more than 5 instances and we are unable to track them without customer complaining about connectivity, hence trying to be proactive.
Can we try something like
osql
or sqlcmd
?
Asked by Techflu
(19 rep)
Jan 15, 2015, 11:49 AM
Last activity: Jul 19, 2025, 12:05 PM
Last activity: Jul 19, 2025, 12:05 PM