Tutorial: Create an Azure SQL Database
This tutorial guides you through the process of creating your first Azure SQL Database using the Azure portal. Follow these steps to get your database up and running.
Step 1: Sign in to the Azure portal
Navigate to the Azure portal and sign in with your account.
Step 2: Navigate to SQL databases
In the Azure portal search bar, type "SQL databases" and select it from the services list.
Click the + Create button to start the creation process.
Step 3: Configure basic settings
On the Basics tab:
- Subscription: Select your Azure subscription.
- Resource group: Choose an existing resource group or click Create new to create one. A resource group is a logical container for your Azure resources.
- Database name: Enter a unique name for your SQL database (e.g.,
MySampleDatabase).
- Server:
- If you have an existing SQL server, select it from the dropdown.
- To create a new server, click Create new. Enter a unique server name, choose a region, and configure server admin login and password.
- Want to use SQL elastic pool?: Select No for this tutorial.
- Compute + storage: Click Configure database. For this tutorial, choose a Basic tier with a small vCore count and storage. You can adjust this later. Click Apply.
Step 4: Configure networking
Navigate to the Networking tab.
- Connectivity method: For this tutorial, select Public endpoint.
- Firewall rules:
- Allow Azure services and resources to access this server: Set to Yes.
- Add current client IP address: Click Yes to allow connections from your current IP address. This is important for connecting to the database later.
Step 5: Additional settings (Optional)
You can explore the Additional settings and Tags tabs for more advanced configurations. For this tutorial, defaults are acceptable.
Step 6: Review and create
Go to the Review + create tab. Azure will validate your configuration.
If validation passes, click the Create button.
The deployment process will begin. This may take a few minutes. You will receive a notification when the deployment is complete.
Tip: For development and testing, consider using the Free tier or DTU-based purchasing models for cost-effectiveness.
Next Steps
Congratulations! You have successfully created an Azure SQL Database. Your next steps might include:
Connect to Your Database