Installing SQL and enabling always on HA

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. If using EMS 7.0.7 or an earlier version, on the FILESTREAM tab, do the following:
   1. Select Enable FILESTREAM for Transact-SQL access.
   2. Select Enable FILESTREAM for File I/O access.
   3. In the Windows share name field, enter MSSQLSERVER.
   4. Select Allow remote clients access to FILESTREAM data.
5. On DBSRV-2, repeat steps 1-4 to complete the always on availability group configuration.