Citrix Provisioning 2106

Enable SQL Server Always On multi-subnet failover

Citrix Provisioning supports SQL Server Always On failover in multi-subnet environments. The Citrix Provisioning server requires Microsoft OLE DB Driver for SQL Server. Microsoft OLE DB Driver fully supports Always On availability groups.

Ensure that the provisioning server is configured to use the Always On availability group listener as the database server name. You do not need to use any instance name. When you use the availability group listener, enable multiSubnetFailover.

Tip:

The SQL server native client is part of the Citrix Provisioning installer. No additional installation procedures are necessary to use this functionality.

Enable always on failover using the Enable MultiSubnetFailover for SQL field on the Database Server page in the Citrix Provisioning Configuration Wizard. To avoid potential configuration conflicts with other Citrix Virtual Apps and Desktops components, use only the configuration wizard to enable this feature.

Note:

For more information, see SQL Always On for SQL Server 2012, 2014, 2016 and 2017.

To enable SQL server always on in multi-subnet environments

  1. After launching the Citrix Provisioning Configuration Wizard, access the Database Server screen.
  2. In the Database Server screen:
    • Specify the Always On availability group listener in the Server name field.
    • Specify the Instance name.
    • Optionally specify the TCP port number.
  3. Select the Enable MultiSubnetFailover for SQL Server Always On check box.
  4. Click Next to continue with the configuration wizard.

Image of the configuration wizard

Enable SQL Server Always On multi-subnet failover