Enable SQL Server Always On multi-subnet failover
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 theEnable MultiSubnetFailover for SQLfield on theDatabase Serverpage in the Provisioning Services Configuration Wizard.
Note
For more information, refer to年代QL always on for SQL Server 2012 and 2014.
To enable SQL server always on in multi-subnet environments:
- After launching the Provisioning Services Configuration Wizard, access theDatabase Serverscreen.
- In the Database Server screen:
- 年代pecify the Always On availability group listener in the Server name field.
- 年代pecify the Instance name.
- Optionally specify the TCP port number.
- 年代elect theEnable MultiSubnetFailover for SQL Server Always Oncheckbox.
- ClickNextto continue with the configuration wizard.