Citrix Provisioning

Enable SQL Server Always On multi-subnet failover

May 11, 2020

Contributed by:

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

After launching the Citrix Provisioning Configuration Wizard, access the Database Server screen.
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.
Select the Enable MultiSubnetFailover for SQL Server Always On check box.
Click Next to continue with the configuration wizard.

Image of the configuration wizard

The official version of this content is in English. Some of the Cloud Software Group documentation content is machine translated for your convenience only. Cloud Software Group has no control over machine-translated content, which may contain errors, inaccuracies or unsuitable language. No warranty of any kind, either expressed or implied, is made as to the accuracy, reliability, suitability, or correctness of any translations made from the English original into any other language, or that your Cloud Software Group product or service conforms to any machine translated content, and any warranty provided under the applicable end user license agreement or terms of service, or any other agreement with Cloud Software Group, that the product or service conforms with any documentation shall not apply to the extent that such documentation has been machine translated. Cloud Software Group will not be held responsible for any damage or issues that may arise from using machine-translated content.

Was this helpful

Enable SQL Server Always On multi-subnet failover

May 11, 2020

Contributed by:

May 11, 2020

Contributed by:

Enable SQL Server Always On multi-subnet failover

To enable SQL server always on in multi-subnet environments

In this article