Tag Archives for " Endpoint "

Dec 21

AlwaysOn – Connection Handshake Failure

By Ginger Daniel | SQL Administration , SQL Server

While doing some work on a test environment recently I realized the AlwaysOn Group was failing. (On a production system I would have had several Alerts set to notify me of any issues). The dashboard on my test instance showed that the secondary replica was not synchronizing and from clicking on the blue warning links […]

Aug 03

AlwaysOn – Endpoint Ownership

By Ginger Daniel | SQL Administration , SQL Server

It is not uncommon for a DBA or other IT staff to set up AlwaysOn in a SQL environment and later leave the company. We ran into this recently with a client and were asked to delete the previous employee’s login from everything SQL related. We were able to remove the login from all databases […]