Create an Azure SQL database using the Azure portal

1

Sign in to Azure

Open your web browser and go to Azure portal.

Sign in with your Azure account credentials.

2

On the Azure portal menu, select Create a resource.

In the Search the Marketplace box, type SQL Database and then select SQL Database from the results.

On the SQL Database page, select Create.

3

On the Basics tab of the Create SQL Database page, provide the following information:

Subscription: Select your Azure subscription.
Resource group: Select an existing resource group or select Create new and enter a unique name for the new resource group.
Database name: Enter a unique name for your database.
Server:
- Select Create new to create a new SQL server.
- In the New server dialog, enter a unique server name, a server admin login, and a password.
- Click OK.
Workload environment: Select Development.
Compute + storage: Click Configure database.
- For this quickstart, select the Basic compute tier.
- Click Apply.

4

Click the Networking tab.

For this quickstart, select Public endpoint for Network connectivity.

Ensure Allow Azure services and resources to access this server is set to Yes.

Under Firewall rules, select Add current client IP address to allow your current IP address to connect to the server.

5

Click the Review + create tab.

Review the summary of your database configuration.

Click Create.

6

The deployment process will begin. You can monitor the progress on the deployment page.

Once the deployment is complete, click Go to resource to view your newly created SQL database.

7

Congratulations! You have successfully created an Azure SQL database. Here are some next steps:

Connect to your database: Use tools like SQL Server Management Studio (SSMS) or Azure Data Studio to connect.
Query your database: Learn how to write T-SQL queries to interact with your data.
Explore security features: Understand how to secure your database.

Explore connection options