Step-By-Step Demo Of Creating Azure Virtual Network, Subnets And Network Security Groups - Part Two

This is the second part of a series where I am going to explain how to create an Azure Virtual Network, Subnets, and Network Security Groups and how to associate them with Virtual Machines.
If you have missed Part 1, you can read it here.
To understand more about what Virtual Networks, Subnets, Network Security Groups are and topics around them, read my article here.
You will need an Azure Subscription to go ahead with this demo.
Step 1

Create a new Virtual Machine with Windows Server 2012 R2 Datacenter.
Step 2

When you click on "Create", a new blade will be opened.
Step 3

Fill out the fields in the basic settings. Use the existing resource group that you had created for the virtual network and click on OK.
Step 4

For the size and configuration, use DS1_V2 Standard type and click on Select.
Step 5

Keep yes on the managed disks. The Virtual Network would be chosen by default. Select the subnet as FrontEndSubnet and keep the public IP address as it is.
Step 6

Keep the Network Security Group as none. Since we have already added NSG to our subnet, we don't need to add it here again. Basically, you can add NSG to either of the three levels i.e. at the VNet level, at the subnet level or at the VM level.
Step 7

Create a new availability set and give a name to it. Keep the fault domains as 2 and keep the update domains as 5. (If you want to read about what are Availability Sets, Fault Domains and Update Domains, read my article here).
Step 8

Keep the Boot Diagnosis and Guest OS Diagnosis as disabled.
Step 9

Click on create.
Step 10

Now we need to create one more VM that will be for the SQL server.
Step 11

Click on Virtual Machines, click on Add and search for SQL Server. Select SQL Server 2014 SP Enterprise on Windows Server 2012 R2 and click on create.
Step 12

Configure the basic settings and click on OK.
Step 13

Now since it is for the database, it is going to show me a highly configured VM to choose. But since this is just for our demo purposes, we are going to choose a lower configuration one.
Step 14

Click on view all and select the DS1_VS2 standard configuration.
Step 15

Choose the subnet as BackEndSubnet.
Step 16

Now, since we are not going to expose this database publicly, we don't need a public IP address. So for that, choose None.
Step 17

For the NSG as well, choose none because we have applied NSG at the subnet level itself. Rest as it is. Click on OK.
Step 18

In the SQL Server settings, choose the SQL connectivity as Private where the database can be accessed from within the VNet only. Keep the port number as default. Enable SQL Authentication.
Step 19

Keep the storage configuration as general where the IOPS (Input/Output Operations per second) is 3200, throughput is 48 MBps and storage size is 1TB. Now, in every VM, there would be just one dist i.e. the OS Disk. But since this is SQL Server, it is also going to add a data disk as well. Keep the storage optimization as "General" and click on OK.
Step 20

Keep everything else as default and click on OK.
Step 21

Once the validation gets passed, click on Create.
Step 22

If you go to your resource group, you will able to see everything that you have created. It has also created Network Interface Cards by default for each VM. Now we are going to connect to our first VM.
We will do that and more in the next and final part of this article. 
The link to the third part of this article is here.