imageOne of the more common workloads the cloud handles fantastically is for your web service.  Whether you want to have your website external or internal facing using Azure web services can help to alleviate the workload on your local infrastructure.   The web could even help alleviate even some of the workload for your websites.  So for the post today I wanted to take you through how to deploy a web application with load balanced web servers.  Also this will be the Instructor led lab I will be delivering at TechEd: Join Me at TechEd North America and Come to my Session: June 3-6 New Orleans!  Let us know what scenarios are you interested in seeing?  Are you currently using Windows Azure, if so how are you using it?  Let us know and email me mhester@microsoft.comor comment on this post.  We will try to include them in this series.   Also remember to sign up for your free Window Azure trial: Get Started TODAY with a FREE 90-DAY Windows Azure Subscription

You can find the full series here: 20 Key Scenarios with Windows Azure

In the following guide you are going to learn how to deploy a simple ASP.NET MVC 4 Web application to a Web server hosted in Windows Azure, using SQL Server and configuring load balancing.  The guide below is geared to Windows Server 2012 and IIS (Internet Information Services),  however you can also do the lab with Apache and Linux.  Take a look at this guide here: HOL-IntroToWindowsAzureVirtualMachinesLinux.

Once you've complete this step-by-step guide, you'll have a cloud-based virtual SQL Server 2012 lab environment that you can use to explore the other new DBA and BI capabilities in this latest version of SQL Server!

Objectives

In this step-by-step guide, you will learn how to:

  • Create virtual machines in a Web Farm using Windows Azure Management Portal
  • Configure Load Balancing in Windows Azure
  • Deploy a simple web application that consumes SQL Server 2012 databases
  • Create a virtual machine with the SQL Server 2012 Full-Text Search feature to be consumed by the web application

Prerequisites

The following is required to complete this step-by-step guide:

  • A copy of the CloudShop sample web application
    DO IT: Download the CloudShop sample web application
  • A Windows Azure subscription with the Virtual Machines Preview enabled.
    DO IT: Sign up for a FREE Trial of Windows Azure
    NOTE: When activating your FREE Trial for Windows Azure, you will be prompted for credit card information.  This information is used only to validate your identity and your credit card will not be charged, unless you explicitly convert your FREE Trial account to a paid subscription at a later point in time. 

Exercises

This step-by-step guide includes the following exercises:

  1. Creating VMs for Windows Server 2012 IIS
  2. Creating a SQL Server 2012 VM
  3. Deploying a Simple Web Application

 

Exercise 1: Creating VMs for Windows Server 2012 IIS

In this exercise, you will learn how to create a Virtual Machine in Windows Azure. Then, you will configure an Internet Information Server adding roles to use later on in this guide.

Task 1.1 - Creating IIS VMs

In this task, you will provision a Virtual Machine and configure the Load Balancing to host a web application.

1. Open Internet Explorer and browse https://manage.windowsazure.com/ to enter the Windows Azure portal. Then, log in with your credentials.

2. In the menu located at the bottom, select New | Compute | Virtual Machine | From Gallery to start creating a new virtual machine.

clip_image001

Creating a new Virtual Machine

3. In the VM OS Selection page, click Platform Images on the left menu and select the Windows Server 2012 Datacenter OS image from the list. Click the arrow to continue.

4. In the VM Configuration page, choose the most current version release date. Enter the Virtual Machine Name (i.e. "iisvm1") and the administrator user name and the administrators Password. This password needs to contain three of these - lower case characters, uppercase characters, numbers and special characters. Make sure you remember your choice. Click the right arrow to continue.

clip_image003

Creating a VM - Configuration

Note: It is suggested to use secure passwords for admin users, as Windows Azure virtual machines could be accessible from the Internet knowing just their DNS.

You can also read this document on the Microsoft Security website that will help you select a secure password: http://www.microsoft.com/security/online-privacy/passwords-create.aspx

5. In the VM Mode page, select Standalone Virtual Machine, enter the DNS Name, select a Storage Account or leave the default value Use Automatically Generated Storage Account, and select a Region/Affinity Group/Virtual Network. Click the right arrow to continue.
Note that when selecting a DNS Name, you will need to specify a Unique DNS Name in the public cloudapp.net DNS namespace.  When a unique name has been specified, you will be notified with a green checkmark icon in this field, as shown below.

clip_image004

Creating a VM - VM Mode

6. In the VM Options page, leave the default values and click the Finish button to create a new VM.

clip_image005

Creating a VM - VM Options

7. In the Virtual Machines section, you will see the VM you created with a Starting (provisioning) status. Wait until it changes to Running in order to continue with the following step as you will need a provisioned VM on the following steps.

clip_image006

Creating VM for IIS Web Farm

Note: It will take from 8 to 10 minutes for the Virtual Machine to complete the provisioning process.

8. You will now add the second VM for the IIS Load Balancing. In the portal, select New | Compute | Virtual Machine | From Gallery.

9. In the VM OS Selection page, click Platform Images on the left menu and select the Windows Server 2012 Datacenter image from the list. Click the arrow to continue.

10. In the VM Configuration page, enter the Virtual Machine Name (i.e. "iisvm2"), the administrator user's Name and Password and the Size. Click the right arrow to continue.

11. In the VM Mode page, select Connect to existing Virtual Machine and choose the first VM you created from the drop down list. Select a Storage Account or leave the default value Use Automatically Generated Storage Account and click the right arrow to continue. This step adds the new virtual machine to the cloud service created in the previous step. This allows the virtual machines to be on the same virtual network.

clip_image007

Creating a VM - VM Mode

12. In the VM Options page, leave the default values and click the button to create a new VM.

13. Wait until the second VM is created. You can check the VM status from the Virtual Machines section within the portal.

Note: It will take from 8 to 10 minutes for the Virtual Machine to complete the provisioning process.

14. After creating the second VM, you will create an endpoint in the port 80 in the Virtual Machine you created first. To do this, click on the first VM Name (iisvm1) to go to the Dashboard page and then click Endpoints. Click Add Endpoint on the bottom pane.

clip_image008

Selecting Add Endpoint in the dashboard

15. Make sure that Add Endpoint option is selected and then click the right arrow button to continue.

clip_image009

Adding a new Endpoint

16. In the Specify endpoint details page, set the Name to webport, the Protocol to TCP and the Public Port and Private Port to 80. Click the button to create the endpoint. Wait until the Endpoint is created before continue to the following steps.

clip_image010

New Endpoint Details

Note: It will take some minutes to create a new endpoint.

17. Now, create a new Endpoint in the second VM in order to enable Load Balancing between both VMs. To do this, click Virtual Machines and then select the second VM you created. Then, click Endpoints.

18. Click Add Endpoint, select Load Balance Traffic On An Existing Endpoint option. Select the endpoint you created for the first VM from the drop down list and then click the right arrow to continue.

clip_image011

Load Balance Traffic An Existing Endpoint

19. In the New Endpoint Details page, set the Name to webport and the Private Port to 80. Click the button to create the endpoint.

Note: It will take some minutes to create a new endpoint.

20. In the Virtual Machines section, click on the first VM Name (iisvm1) and then click Endpoints.

21. Select the webport endpoint you have created. Make sure the Load Balancer column value is Yes.

clip_image012

Verification: enabling IIS Load Balancing

22. Click the Edit Endpoint button in the bottom bar to enter the endpoint details and verify the load balancing is enabled. Repeat this step in the second VM.

clip_image013

Verification: enabling IIS Load Balancing, details

Task 1.2 - Configuring IIS VMs

In this task, you will configure the IIS VMs by adding the necessary roles to deploy the web application.

1. In the Portal, click Virtual Machines on the left menu.

2. You will see a list with your existing VMs. Select the first one you created in Task 1 and click the Connect button in the bottom bar. If you used the proposed name, this VM should be named iisvm1.

3. You will be asked to download the remote desktop settings file. Click Open and log on using the Administrator credentials you defined when creating the VM.

4. In the Azure VM, open Server Manager using the first icon on the taskbar..

5. In the Server Manager window, select the Manage menu in the top-right navigation bar and select Add Roles and Features.

clip_image014

Server Manager

6. On the Before You Begin page of the Add Roles and Features Wizard, read the content and click Next.

7. Step through the Add Roles and Features Wizard with the following selections:

  • Installation Type: Select Role-based or feature-based installation and click the Next button.
  • Select destination server: Select a server from the server pool, and select the local server name (iisvm1 or iisvm2).  Click the Next button.
  • Roles: Select Application Server and Web Server (IIS). Click the Next button.  A warning will show, informing the Required Role Services that are missing. Click Add Required Features to install them and then click Next.
  • Features: Accept the default selections and click the Next button
  • Application Server Role services: Select .NET Framework 4.5 and Web Server (IIS) Support.  Click the Next button.
  • Web Server (IIS) Role Services: Accept the default selections and click the Next button.

8. On the Confirm installation selections page of the Add Roles and Features Wizard, click the Install button to install the selected roles, role services and features.

9. Close the Remote Desktop Connection.

10. Repeat this task on the second VM to install IIS. If you used the proposed name, the second VM should be named iisvm2.

Exercise 2: Creating a SQL Server 2012 VM

In this exercise, you will create a new VM and learn how to install SQL Server. You will add disk images to the existing VM in order to split the data from the logs generated by SQL Server.

Task 2.1 - Creating a SQL Server VM

In this task, you will create a new VM using the Windows Azure portal in the same Cloud App you deployed the IIS VMs.

1. In the menu located at the bottom, select New | Compute | Virtual Machine | From Gallery to start creating a new virtual machine.

2. In the VM OS Selection page, click Platform Images on the left menu and select the Microsoft SQL Server 2012 SP1 Enterprise On Windows Server 2008 R2 Service Pack 1 image from the list. Click the arrow to continue.

3. In the VM Configuration page, enter the Virtual Machine Name (i.e. "sqlvm1"), the administrator user's Name and Password and the Size. Click the right arrow to continue.

4. In the VM Mode page, select Connect to existing Virtual Machine and choose the first IIS VM you created from the drop down list (iisvm1). Click the right arrow to continue.

5. In the VM Options page, leave the default values and click the button to create a new VM.

6. In the Virtual Machines section, you will see the VM you created with a provisioning status. Wait until it changes to Running in order to continue with the following step.

Note: It will take from 8 to 10 minutes for the Virtual Machine to complete the provisioning process.

Task 2.2 - Attaching Empty Disk Images

In this task, you will create two empty data disks and attach them to an existing VM using the Windows Azure Management Portal. You will use these data disks to split SQL Server Data and Logs.

1. Now, you will create and attach empty data disks to store the SQL Server logs and data files, and you will also add an endpoint. To do this, in the Virtual Machines section, select the SQL Server VM you created in the previous task.

2. In the VM's Dashboard, click Attach in the menu at the bottom of the page and select Attach Empty Disk.

clip_image015

Attach Empty Disk

3. In the Attach Empty Disk page, set the Size to 50 GB and create the Disk.

4. Wait until the process to attach the disk finishes. Repeat the steps 1 to 3 to create a second disk.

5. Open the VM's Dashboard. You will see three disks: one for the OS and other two for Data and Logs.

Note: It might take a few minutes until the data disks appear in the VM's dashboard within the Azure Portal.

clip_image016

Attached Data Disks

6. Finally, you need to format the disks in order to access them from the Virtual Machine. To do this, click Connect to connect to the VM using Remote Desktop connection.

7. It will ask you to download the remote desktop settings file. Click Open and log on using the Admin credentials you defined when creating the VM.

8. In the Virtual Machine, open Server Manager from Start | All Programs | Administrative Tools.

9. Expand Storage node and select Disk Management option.

clip_image017

Disks Management

10. The Initialize Disk dialog will appear. Leave the default values and click OK.

11. Right-click the first disk unallocated space and select New Simple Volume.

clip_image018

Disks Management

12. Follow the New Simple Volume Wizard. When asked for the Volume Label use SQLData.

13. Wait until the process for the first disk is completed. Repeat the steps 11 to 12 but this time using the second disk. Set the Volume Label to SQLLogs.

14. The Disk Management list of available disks should now show the SQLData and SQLLogs disks like in the following figure:

clip_image019

Disk Management

Note: Do not close the Remote Desktop Connection. You will use it in the following task.

Task 2.3 - Configuring SQL Server in the VM

In this task, you will configure SQL Server 2012. You will create the database that will be used by the web application and add Full-Text Search capabilities to it. Additionally, you will create a SQL Server user for the website.

1. Open Windows Explorer and create the following folders: F:\Data, G:\Logs and G:\Backups.

2. Open the SQL Server Management Studio from Start | All Programs | Microsoft SQL Server 2012 | SQL Server Management Studio.

3. Connect to the SQL Server 2012 default instance using your Windows Account.

4. Now, you will update the database's default locations in order to split the DATA from the LOGS. To do this, right click on your SQL Server instance and select Properties.

5. Select Database Settings from the left side pane.

6. Locate the Database default locations section and update the default values to point to the disks you attached in the previous task and then click "Ok".

clip_image020

Setting Database Default Locations

7. Now, a service restart is necessary for the changes to take effect. In order to restart the service, right click on your SQL Server instance and select Restart from the context menu.

8. Restart SQL Server. In the Object Explorer, right-click on the server node and select Restart.

9. In order to enable downloads from Internet Explorer you will need to update Internet Explorer Enhanced Security Configuration. In the Azure VM, open Server Manager from Start | All Programs | Administrative Tools.

10. In the Server Manager, click Configure IE ESC within Security Information section.

clip_image021

Configuring IE ESC

11. In the Internet explorer Enhanced Security configuration, turn off the enhanced security for Administrators and click OK.

clip_image022

Internet Explorer Enhanced Security

Note: Modifying Internet Explorer Enhanced Security configurations is not good practice and is only for the purpose of this particular step-by-step guide. The correct approach should be to download the files locally and then copy them to a shared folder or directly to the VM.

12. This guide uses the AdventureWorks database. Open an Internet Explorer browser and go to http://msftdbprodsamples.codeplex.com/ to download the SQL Server 2012 sample databases. Once on the page click SQL Server 2012 DW and then download Adventure Works 2012 Data File. Download the file to F:\Data.

Note: The AdventureWorks database can also be downloaded as a .zip file. If you choose this format, right-click the file to open its properties window and then click Unblock. Then, extract the database to F:\Data.

13. Add the AdventureWorks sample database to your SQL Server. To do this, in the SQL Server Management Studio, locate your SQL Server instance node and expand it. Right click the Databases folder and select Attach.

clip_image023

Attaching the database

14. In the Attach Databases dialog, press Add. Browse to the data disk and select the Adventure Works data file.

15. Select the AdventureWorks2012 Log entry and click Remove.

clip_image024

Removing AdventureWorks2012 Log entry

16. Press OK to add the database.

17. In the Databases folder, locate the new AdventureWorks2012 database and explore its tables.

clip_image025

AdventureWorks Sample Database

18. Expand Storage node within AdventureWorks database, right-click Full Text Catalogs folder and select New Full-Text Catalog.

Note: You are creating a Full Text Catalog for the database that will be used later by the web application.

clip_image026

Create New Full-Text Catalog

19. In the New Full-Text Catalog dialog, set the Name value to AdventureWorksCatalog and press OK.

clip_image027

Create New Full-Text Catalog

20. Check that the Full-Text Catalog you created appears in the Full-Text Catalogs folder.

clip_image028

Create New Full-Text Catalog

21. Right-click AdventureWorksCatalog and select Properties. In the Full-Text Catalog Properties dialog, switch to Tables/Views page.

22. Add the Production.Product table to the Table/View objects assigned to the Catalog list. Then, check the Name column and click OK.

clip_image029

Create New Full-Text Catalog

23. Add a new user for the web application you will deploy in the following exercise. To do this, expand Security folder within the SQL Server instance. Right-click Logins folder and select New Login.

clip_image030

Creating a New Login

24. In the General section, set the Login name to CloudShop. Select SQL Server authentication option and set the Password to Azure$123.

Note: If you enter a different username or password than those suggested in this step, do not forget in the next exercise to update the web.config file of the web application to match those values.

25. Unselect Enforce password policy checkbox to avoid having to change the password the first time you log on, and set the Default database to AdventureWorks.

clip_image031

Creating a New Login

26. Click User Mapping on the left pane. Select the map checkbox in the AdventureWorks database row and click OK.

clip_image032

Mapping the new User to the AdventureWorks Database

27. Expand AdventureWorks database within Databases folder. In the Security/Users folder, double-click CloudShop user.

28. Select the Membership page, and select the db_owner role checkbox for the CloudShop user and click OK.

clip_image033

Adding Database role membership to CloudShop user

Note: The application you will deploy in the next exercise uses Universal Providers to manage sessions. The first time the application runs, the provider will create the Sessions table within the database. For that reason, you are assigning a db_owner role to the CloudShop user. Once you run the application for the first time, you can remove this role as these permissions will not be needed.

29. Now, enable Mixed Mode Authentication to the SQL Server instance. To do this, in the SQL Server Management Studio, right-click the server instance and click Properties.

30. Click Security in the left side pane and then select SQL Server and Windows Authentication mode under Server Authentication section. Click OK to save changes.

31. Restart the SQL Server instance. To do this, right-click the SQL Server instance and click Restart.

32. Close the SQL Server Management Studio.

33. In order to allow the web application access the SQL Server database you will need to add an Inbound Rule for the SQL Server requests in the Windows Firewall. To do this, open Windows Firewall with Advanced Security from Start | All Programs | Administrative Tools.

34. Select Inbound Rules node, right-click it and select New Rule to open the New Inbound Rule Wizard.

clip_image034

Creating an Inbound Rule

35. In the Rule Type page, select Port and click Next.

clip_image035

New Inbound Rule Wizard

36. In Protocols and Ports page, leave TCP selected, select Specific local ports, and set its value to 1433. Click Next to continue.

clip_image036

New Inbound Rule Wizard

37. In the Action page, make sure that Allow the connection is selected and click Next.

clip_image037

New Inbound Rule Wizard

38. In the Profile page, leave the default values and click Next.

39. In the Name page, set the Inbound Rule's Name to SQLServerRule and click Finish

clip_image038

New Inbound Rule Wizard

40. Close Windows Firewall with Advanced Security window.

Note: Make sure the Named Pipes and TCP/IP protocols are enabled for the Server Instance. You can verify this by going to the SQL Server Configuration Manager and within SQL Server Network Configuration node check that these protocols' status are set to enable.

Remember to restart the SQL Server instance after enabling a protocol.

41. Close the Remote Desktop Connection.

Exercise 3: Deploying a Simple Web Application

In this exercise, you will learn how to deploy a simple web application in the IIS of the Azure Virtual Machine you have previously configured.

Note: To make this solution highly available, you need to configure the SQL Servers in an availability set and set up SQL Server Mirroring between the instances.

Task 3.1 - Deploying a Simple Web Application

In this task, you will deploy the web application to the IIS VMs.

1. In the Azure Portal, Click Virtual Machines on the left menu.

2. You will see a list with your existing VMs. Select the first one you created in Exercise 1 and click Connect. If you used the proposed name, this VM's should be named iisvm1.

3. You will be prompted to download the remote desktop client. Click Open and log on using the Administrator credentials you defined when creating the VM.

4. Open wwwroot folder located at C:\inetpub\wwwroot and copy the CloudShop.zip file that you downloaded at the beginning of this step-by-step guide to this folder. To do this, copy CloudShop.zip (Ctrl + C) and paste it (Ctrl + V) in the VM's wwwroot folder. Extract all files to C:\inetpub\wwwroot\CloudShop folder.

clip_image039

wwwroot folder

5. Open with Notepad the Web.config file located in C:\inetpub\wwwroot\CloudShop. At the end of the file, replace the connection strings placeholder with the name of your SQL Server (by default, is the VM's name)  You should do this twice in the file.

XML Example

<connectionStrings>

data source=[ENTER YOUR SQL SERVER NAME];
initial catalog=AdventureWorks2012;
Uid=CloudShop;
Password=Azure$123;

</connectionStrings>

6. Open the Internet Information Services (IIS) Manager from the Server Manager –> Tools menu.

7. In the Connections pane, expand Default Web Site within your IIS Server's node. You will see the CloudShop folder you copied in the wwwroot folder.

clip_image040

IIS Manager

8. Right-click CloudShop folder and select Convert to Application.

clip_image041

IIS Manager - Convert to Application

9. In the Add Application dialog, click OK.

clip_image042

Add Application dialog

10. Finally, select the Application Pools node and double-click DefaultAppPool application pool.

clip_image043

Updating Default Application Pool

11. In the Edit Application Pool dialog, confirm that the .Net Framework version is set to v4.0 and click OK.

clip_image044

Editing Application Pool

12. Close the Internet Information Server (IIS) Manager window.

13. Close the Remote Desktop Connection.

14. Repeat this task in the second VM you created in Exercise 1 -Task 1.1. If you used the proposed name, this VM should be named iisvm2.

Task 3.2 - Verification

In this task, you will test the Cloud Shop web application you deployed in the previous task.

1. On your local machine, open Internet Explorer.

2. Go to http://[YOUR-SERVICE-NAME].cloudapp.net/CloudShop. The Service Name is the one you used when creating the IIS VMs (you can also check it in the Azure Portal, within VM's dashboard).

clip_image045

CloudShop Web Application running in the Web Farm

3. In the Search box, write Classic and click Search. It will show all the products that have a product name that match the search criteria.

clip_image046