Use Case

Losing connection to the SQL Server can happen on a day to day basis and we want to be notified when it happens. I.E, this is what happens when the master server is having SQL Connectivity Errors

Configuration

Download the powershell file below

- Change the ip address to be the sql servers ip address as seen below:

Then on line 5 swap the following: 

Set up Task Scheduler task to be run script every hour: