Determining the presence of SQL Always-On

How to tell if I have a SQL Always-on configuration

• Server Migration

• Multiple Database servers

• On-Prem

Tyler employees may ask if this is a configuration you currently have.  Most notably at time of a server migration for on-prem clients.  The time involved with this type of setup takes longer so knowing if you have Alway-on is important.

1. Connect to Sql Server Management Studio (SSMS) and connect to an existing Munis DB server. 
   a. expand the Always On High Availability folder 
   b. if a warning appears The Always On feature must be enabled for the server instance <instancename> before you can create an availability group on this instance.   They do not have AO. 

2. Review your last server transfer site report. 
       a. On roughly page 4 there is a section called SQL Always On Configurations and DB server names listed. if this is blank, not filled out or not present then they do not have AO

The presence of a SQL Always-On configuration may not always be apparent.