Determining the presence of SQL Always-On

Owned by Knowledge Assistant
Dec 04, 2023
1 min read



Description of Issue

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





Context

  • Server Migration

  • Multiple Database servers

  • On-Prem





Cause

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.



Resolution

  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



Additional Information

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