Product Documentation

Enable SQL Server Always On multi-subnet failover

Sep 13, 2016

PVS supports SQL Server Always On failover in multi-subnet environments. As part of the implementation, the database server is accessed via ODBC which requires the SQL Server Native Client be installed as a pre-requisite of the PVS server software.  

You must ensure that the PVS server is connecting to an Always On availability group listener of Failover Cluster Instance when enabling MultiSubnetFailover.

Tip

The SQL Server Native Client is part of the PVS installer. No additional installation procedures are necessary to use this functionality.

This feature is enabled using the Enable MultiSubnetFailover for SQL field on the Database Server page in the Provisioning Services Configuration Wizard.

Note

For more information, refer to SQL always on for SQL Server 2012 and 2014.

To enable SQL server always on in multi-subnet environments:

  1. After launching the Provisioning Services 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 checkbox.
  4. Click Next to continue with the configuration wizard.
localized image