Installing SQL and enabling always on HA

The following assumes that you are logged in as a user in the local administrators group. Otherwise, you may not have the permissions to perform the configuration.

To install SQL and enable always on HA:

1. Configure an always on high availability group on DBSRV-1:
   1. On DBSRV-1, execute the SQL Server installer that you downloaded.
   2. Select New SQL Server stand-alone installation or add features to an existing installation.
   3. In the example, Default instance is selected. If desired, you can select Named instance. Click Next.
   4. On the Server Configuration page, configure the relevant account for services and processes to use. This example uses an Active Directory LAB\administrator account. Using a service account with appropriate permissions is recommended in a production environment. Click Next.

      

   5. On the Database Engine Configuration page, configure the account to use as the database engine administrator. This example uses mixed mode. Click Next.
   6. Continue through the wizard and complete SQL Server installation.
2. Run the SQL Server Configuration Manager and double-click the SQL Server (MSSQLSERVER) service to open the Properties dialog.
3. On the Always On Availability Groups tab, select Enable Always On Availability Groups. The Windows Server Failover Cluster field is autopopulated with the EMS cluster name. Click OK, and restart the SQL Server service.
4. On DBSRV-2, repeat steps 1-4 to complete the always on availability group configuration.