Table of Contents
Create an Azure SQL Database throught Azure portal
1. Visit https://portal.azure.com/#create/hub then create a Azure SQL Database.
![Bg677](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/06/bg677.png)
2. Select Subscription and Resource group to store the SQL Database. Or, you can create a new resource group for testing purpose.
![Bg678](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/06/bg678.png)
3. Next, enter the Database name then select a SQL Server to attach the SQL Database into it. In the first time, I’ll create a new SQL Server.
![Bg679](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/06/bg679.png)
4. Enter SQL server name, it must be unique. For example, my SQL Server address is bonguidessdb.database.windows.net.
- Location: Select location for the SQL Server.
- Authentication method: Use SQL authentication.
- Server admin login: Create sa account for SQL authentication. We’ll using this account to login into SQL Server using SQL Management Studio.
![Bg680](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/06/bg680.png)
5. Database details
- Want to use SQL elastic pool: No.
- Compute and storage: Click Configure database.
![Bg681](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/06/bg681.png)
6. Service and compute tier: Select Serverless.
![Bg682](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/06/bg682-1024x519.png)
7. Backup storage redundancy: Select Local-redundant backup storage then click Next: Networking.
![Bg684](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/06/bg684.png)
8. In Networking section, select Public endpoint then add your current client IP address to the firewall list to allow connect to your SQL Database.
![Bg685](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/06/bg685.png)
9. Finally, click Create button to create the Azure SQL Database.
![Bg686](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/06/bg686.png)
10. It could take several minutes to complete. Once done, click Go to resource to navigate to the SQL Database.
![Bg687](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/06/bg687.png)
Connect to Azure SQL Database
11. In the SQL Database information page, take note the SQL Server name.
![Bg688](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/06/bg688.png)
12. Open SSMS then connect to the SQL Database using SQL server name and the server admin login you’ve created in previous step.
![Bg689](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/06/bg689.png)
13. Expand the Databases folder, and you can see your Azure SQL Database is listed.
![Bg690](https://bonguides-1e199.kxcdn.com/wp-content/uploads/2022/06/bg690.png)