Sample Header Ad - 728x90

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