Product Documentation

SQL AlwaysOn for SQL Server 2012 and 2014

Sep 28, 2016

Provisioning Services supports the SQL AlwaysOn high availability and disaster recovery solution. Note the following:

  • The SQL 2012 native client is required. This is an optional prerequisite in the Provisioning Services server install process.
  • Provisioning Services is only aware of and interacts with AlwaysOn through the listener DNS name.
  • The database must be part of the pre-made high availability group.
  • The listener DNS name and high availability group are part of the procedures to create SQL AlwaysOn. Provisioning Services is not responsible for this.
  • The soap/stream services user must be manually configured to have full permission to each SQL server part of the AlwaysOn configuration.
  • Provisioning Services is not aware of the individual SQL server/cluster behind SQL AlwaysOn.
  • MultiSubnetFailover is not supported.