SQL Server “Denali” AlwaysOn Hands-on Lab VERSION: version 1.0 – Lab Manual Beta Version 1.0 Author: Ted Malone (v-temalo@microsoft.com) SQL Server “Denali” AlwaysOn 2 © 2011 Microsoft Corporation. All rights reserved. Table of Contents Lab Environment .................................................................................................................................... 3 Lab Overview ......................................................................................................................................... 4 About This Lab........................................................................................................................................ 5 Exercise 1: Configuring a Windows Failover Cluster .............................................................................. 6 Exercise 2: Configuring an Availability Group ...................................................................................... 13 Exercise 3: Enabling Read Access to a Secondary Replica ................................................................... 21 Exercise 4: Configuring an Application to Use a ALWAYSON Virtual Network Name ......................... 25 Lab Environment During this lab, you will work in a simulated environment with the following computers or virtual machines. Computers and virtual machines used in this lab This lab uses three virtual machines with the following details: Setting Value Computer Name SQLLABS-DC Function contoso.com Domain Controller Operating System Windows Server® 2008 R2 Computer Name DENALI-SERVER1 Function Microsoft® SQL Server® Primary Replica Operating System Windows Server 2008 R2 SQL Server Instances INSTANCE1 Computer Name DENALI-SERVER2 Function SQL Server Secondary Replica Operating System Windows Server 2008 R2 SQL Ser...
