Citrix Provisioning

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 the SQL server native client. This requirement ensures that database access occurs via the ODBC port.

Ensure that the provisioning server is connecting to an Always On availability group listener containing the Failover Cluster Instance when enabling 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