An Azure SQL server is a relational database management system (RDBMS). It saves data in tables that can be filtered and sliced with SQL queries. Our web app needs a SQL server to save and retrieve data from users.

This page describes how to create an Azure SQL server and connect it to our virtual network’s subnet.

Create a SQL server

  1. Open the main.tf file.

  2. Add the following Terraform code to the bottom of the file:

     resource "azurerm_mssql_server" "mssql_server" {
     name                         = "azure-web-app-mssqlserver"
     resource_group_name          = azurerm_resource_group.rg.name
     location                     = azurerm_resource_group.rg.location
     version                      = "12.0"
     administrator_login          = "Example-Administrator"
     administrator_login_password = "myp@sswoRD11!"
     minimum_tls_version          = "1.2"
 }

 resource "azurerm_mssql_virtual_network_rule" "vnetrule" {
     name      = "sql-vnet-rule"
     server_id = azurerm_mssql_server.mssql_server.id
     subnet_id = azurerm_subnet.subnet.id
 }
  3. Save the main.tf file.

Troubleshooting

TBD

Learn more

TBD

Updated: