Azure SQL Database Documentation

Create and Configure an Azure SQL Database

This tutorial guides you through the process of creating a new Azure SQL Database instance and configuring its basic settings. Follow these steps to get your SQL database up and running on Microsoft Azure.

Prerequisites

• An active Azure subscription. If you don't have one, sign up for a free account.
• Permissions to create resources in your Azure subscription.

Steps to Create and Configure

1. Navigate to the Azure portal

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

2. Create a new SQL Database resource

   In the Azure portal search bar, type "SQL databases" and select "SQL databases" from the results. Click the + Create button.

   

3. Configure Basic settings

   On the "Create SQL Database" page, fill in the following details:

   • Subscription: Select your Azure subscription.
   • Resource group: Create a new one (e.g., myResourceGroup) or select an existing one.
   • Database name: Enter a unique name for your database (e.g., mySampleDatabase).
   • Server: Click Create new to configure a new SQL server or select an existing one.
     • Server name: Choose a globally unique name (e.g., mysampleserver123).
     • Location: Select the Azure region closest to you.
     • Authentication method: Choose SQL authentication.
     • Admin login: Enter a username (e.g., sqladmin).
     • Password: Enter a strong password and confirm it.
     • Click OK.
   • Workload environment: Select Development for testing or Production for live applications.
   • Compute + storage: Click Configure database to choose a performance tier (e.g., Basic, Standard, Premium) and storage size. For this tutorial, the default settings are usually sufficient.
   

4. Configure Networking settings

   Under the Networking tab, you can configure firewall rules. For initial setup, you might want to allow Azure services and resources to access this server. Click Review + create.

5. Review and Create

   Review all the settings you've configured. If everything looks correct, click the Create button.

6. Deployment

   Azure will now provision your SQL database. This may take a few minutes. You can monitor the deployment progress by clicking the notification icon in the top right corner of the portal.

Next Steps

Now that you have successfully created and configured your Azure SQL Database, you can proceed to connect to it from your applications or development tools. Refer to the Connect to Your Database tutorial for more information.