MSMConfig when using a SQL Availability Group Listener
What is an Availability Group Listener?
An availability group listener is a virtual network name (VNN) that clients can connect to in order to access a database in a primary or secondary replica of an Always On availability group. A listener allows a client to connect to a replica without having to know the physical instance name of the SQL Server. Since the listener routes traffic, the client connection string doesn't need to be modified after a failover occurs.
An availability group listener consists of a Domain Name System (DNS) listener name, listener port designation, and one or more IP addresses. Only the TCP protocol is supported by the availability group listener.
Why would this be used in Manitou?
It provides a layer of redundancy in regard to the database connection. When the primary database server goes offline for Maintenance or a catastrophic failure the Listener client connection is automatically redirected to the secondary database server.
What does this look like in MSMConfig?
Configuration Name: Customer can assign any name
Computer: {Virtual Network name}, Port#
Database Service:MSSQLServer
Backup DB Service:MSSQLServer
Server Name:{Virtual Network name}
Database Name: Manitou
Database User: {sa or another custom user}
Database Password: {user password}
