Create an Azure SQL Database

This tutorial will guide you through the process of creating a new Azure SQL Database using the Azure portal. Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and provides high availability without administrator intervention.

Prerequisites

Steps to Create a SQL Database

  1. Sign in to the Azure portal

    Open your web browser and navigate to https://portal.azure.com/. Sign in with your Azure account credentials.

    Azure portal login screen

  2. Navigate to SQL databases

    In the Azure portal search bar at the top, type "SQL databases" and select SQL databases from the search results.

    Azure portal search for SQL databases

  3. Create a new SQL database

    On the SQL databases page, click the + Create button.

    Azure portal SQL databases create button

  4. Configure basic settings

    In the Create SQL Database form, fill in the following details:

    • Subscription: Select your Azure subscription.
    • Resource group: Choose an existing resource group or click Create new to create a new one. A resource group is a logical container for your Azure resources.
    • Database name: Enter a unique name for your database (e.g., mydemodatabase).
    • Server: Click Create new to configure a new SQL server.
      • Server name: Enter a globally unique name for your server (e.g., mydemoserver123).
      • Location: Select the Azure region where you want to deploy your server and database.
      • Administrator login: Enter a username for the server administrator (e.g., azureuser).
      • Password: Enter a strong password and confirm it.
      • Click OK.
    • Want to use SQL elastic pool?: Select No for this tutorial.
    • Compute + storage: Click Configure database.
      • For this tutorial, select the Basic tier. You can adjust the compute size and storage as needed for your workload.
      • Click Apply.
    Azure portal create SQL database basic settings

  5. Configure networking

    Navigate to the Networking tab.

    • Connectivity method: Select Public endpoint.
    • Firewall rules: Ensure Allow Azure services and resources to access this server is set to Yes. You can add your current client IP address for easier access later.
    Azure portal create SQL database networking settings

  6. Review and create

    Navigate to the Review + create tab. Review your configuration details. If everything looks correct, click the Create button.

    Azure portal create SQL database review and create

  7. Deployment

    Azure will now deploy your SQL server and database. This process may take a few minutes. You will see a deployment notification, and once complete, you can click Go to resource to view your new SQL database.

    Azure deployment success notification

Congratulations! You have successfully created an Azure SQL Database. You can now proceed to connect to it and start working with your data.

Next Steps

Now that your Azure SQL Database is created, you can: