Quickstart: Create a SQL Server 2017 Windows virtual machine in the Azure portal

This quickstart steps through creating a SQL Server virtual machine in the Azure portal.

Tip

Get an Azure subscription

If you don't have an Azure subscription, create a free account before you begin.

Select a SQL Server VM image

  1. Sign in to the Azure portal using your account.

  2. In the Azure portal, select Create a resource.

  3. In the search field, type SQL Server 2017 Developer on Windows Server 2016, and press ENTER. Expand the SQL Server 2017 on Windows Server 2016 option.

  4. Select the Free SQL Server License: SQL Server 2017 Developer on Windows Server 2016 image. The Developer edition is used in this tutorial because it is a full-featured edition of SQL Server that is free for development testing purposes. You pay only for the cost of running the VM. For complete pricing considerations, see Pricing guidance for SQL Server Azure VMs.

    New search window

  5. Select Create.

Provide basic details

On the Basics tab, provide the following information:

  1. In the Project Details section, select your Azure subscription and then select Create new to create a new resource group. Type SQLVM-RG for the name.

    Subscription

  2. Under Instance details:

    1. Type SQLVM for the Virtual machine name.
    2. Choose a location for your Region.
    3. For the purpose of this quickstart, leave Availability options set to No infrastructure redundancy required. To find out more information about availability options, see Azure regions and availability.
    4. In the Image list, select Free SQL Server License: SQL Server 2017 Developer on Windows Server 2016.
    5. Choose to Change size for the Size of the virtual machine and select the A2 Basic offering. Be sure to clean up your resources once you're done with them to prevent any unexpected charges.

    Instance details

  3. Under Administrator account, provide a username, such as azureuser and a password. The password must be at least 12 characters long and meet the defined complexity requirements.

    Administrator account

  4. Under Inbound port rules, choose Allow selected ports and then select RDP (3389) from the drop-down.

    Inbound port rules

SQL Server settings

On the SQL Server settings tab, configure the following options:

  1. Under Security & Networking, select Public (Internet) for SQL Connectivity and change the port to 1401 to avoid using a well-known port number in the public scenario.

  2. Under SQL Authentication, select Enable. The SQL Login is set to the same user name and password that you configured for the VM. Use the default settings for Azure Key Vault integration and Storage configuration.

    SQL server security settings

  3. Change any other settings if needed, and then select Review + create.

    Review + create

Create the SQL Server VM

On the Review + create tab, review the summary, and select Create to create SQL Server, resource group, and resources specified for this VM.

You can monitor the deployment from the Azure portal. The Notifications button at the top of the screen shows basic status of the deployment. Deployment can take several minutes.

Connect to SQL Server

  1. In the portal, find the Public IP address of your SQL Server VM in the Overview section of your virtual machine's properties.

  2. On a different computer connected to the Internet, open SQL Server Management Studio (SSMS).

  3. In the Connect to Server or Connect to Database Engine dialog box, edit the Server name value. Enter your VM's public IP address. Then add a comma, and add the custom port, 1401, that we specified when you configured the new VM. For example, 11.22.33.444,1401.

  4. In the Authentication box, select SQL Server Authentication.

  5. In the Login box, type the name of a valid SQL login.

  6. In the Password box, type the password of the login.

  7. Select Connect.

    ssms connect

Log in to the VM remotely

Use the following steps to connect to the SQL Server virtual machine with Remote Desktop:

  1. After the Azure virtual machine is created and running, click the Virtual Machines icon in the Azure portal to view your VMs.

  2. Click the ellipsis, ..., for your new VM.

  3. Click Connect.

    Connect to VM in portal

  4. Open the RDP file that your browser downloads for the VM.

  5. The Remote Desktop Connection notifies you that the publisher of this remote connection cannot be identified. Click Connect to continue.

  6. In the Windows Security dialog, click Use a different account. You might have to click More choices to see this. Specify the user name and password that you configured when you created the VM. You must add a backslash before the user name.

    Remote desktop authentication

  7. Click OK to connect.

After you connect to the SQL Server virtual machine, you can launch SQL Server Management Studio and connect with Windows Authentication using your local administrator credentials. If you enabled SQL Server Authentication, you can also connect with SQL Authentication using the SQL login and password you configured during provisioning.

Access to the machine enables you to directly change machine and SQL Server settings based on your requirements. For example, you could configure the firewall settings or change SQL Server configuration settings.

Clean up resources

If you do not need your SQL VM to run continually, you can avoid unnecessary charges by stopping it when not in use. You can also permanently delete all resources associated with the virtual machine by deleting its associated resource group in the portal. This permanently deletes the virtual machine as well, so use this command with care. For more information, see Manage Azure resources through portal.

Next steps

In this quickstart, you created a SQL Server 2017 virtual machine in the Azure portal. To learn more about how to migrate your data to the new SQL Server, see the following article.