Sample configuration

Last published : Aug 26, 2026
A sample setup is used to illustrate the installation and configuration tasks for two instances of SQL server, Billing and Payroll. During normal operation, one instance will be online on each of the two servers. If a failure occurs, the instance on the failing node will be brought online on the other server, resulting in two instances running on one server.
During the configuration process, create virtual IP addresses for the following:
  • Billing virtual server (virtual IP address is the same on all nodes)
  • Payroll virtual server (virtual IP address is the same on all node)
  • Cluster IP address
You should have these IP addresses available before you begin to deploy your environment.
The IP addresses are required only in case of IPv4. In an IPv6 network environment, the configuration wizards automatically generate a unique and valid IPv6 address based on the network prefix advertised by the routers.
The following table describes the objects created and used during the installation and configuration.
Table: Active-active configuration objects
Name Description
SYSTEM1 & SYSTEM2 server names
SQL_CLUS1 virtual SQL server cluster
lang=txt volume for the SQL Server system data files for the billing instance
BILLING_VS_SYS_FILES volume for the SQL Server system data files for the payroll instance
PAYROLL_VS_SYS_FILES
lang=txt volume for a SQL Server user-defined database for the billing instance
BILLING_DATA volume for a SQL Server user-defined database for the payroll instance
PAYROLL_DATA
lang=txt volume for a SQL Server user-defined database log file fort he billing instance
BILLING_LOG volume for a SQL Server user-defined database log file for the payroll instance
PAYROLL_LOG
lang=txt volume for the list of registry keys replicated among the nodes for the billing instance
BILLING_REGREP volume for the list of registry keys replicated among the nodes for the payroll instance
PAYROLL_REGREP
lang=txt instance name for the billing instance
BILLING_INST instance name for the payroll instance
PAYROLL_INST
lang=txt virtual SQL server name for the billing instance
BILLING_VS virtual SQL server name for the payroll instance
PAYROLL_VS
lang=txt SQL Server service group for the billing instance
BILLING_SG SQL Server service group for the payroll instance
PAYROLL_SG