Setting Up a VM with SQL Database/Server

In this section, we’ll cover two major topics: setting up VMs with SQL server setup and VMs with Linux OS. Here, we will be setting up a VM with an Azure SQL server but why do we need to use this configuration?

This can save time for organizations that are certain that they need to set up an Azure SQL server. Therefore, they are not required to do that manually, instead, it is ready for them by default and they can start deploying their database on it.

We can use an Azure BACPAC file to import the database into an SQL server, once your SQL server is up and ready in an Azure VM. This is just an additional point for you to try out. You can download it using this Git Hub link.

Note: This has the same steps as the ones we followed for Azure SQL databases but the key difference here is that we have to do it on an Azure VM.

Demo: Creating a VM with SQL Server

Here’s how to create a VM with SQL Server using the Azure Portal.

The Azure Portal

1. Navigate over to Azure Portal and log in.

2. On the Azure home page, click the “Create a resource” button. This will open a marketplace. Search for “Virtual machine accounts” in the search box or scroll down to find it.

3. Click the “Create” button under the “Virtual machine” option. This will open up a form for you to fill out. Select your ...