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.

We must allow the SQL server to connect to the virtual network we created earlier. We do that with a virtual network rule.

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

Define the 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" {
     resource_group_name          = azurerm_resource_group.rg.name
     location                     = azurerm_resource_group.rg.location
     name                         = "azure-web-app-mssqlserver"
     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
 }
    Configuration Definition Example
    name The name of your SQL server. azure-web-app-mssqlserver
    version The SQL server version. 12.0
    administrator_login The administrator’s login username. Exmaple-Administrator
    administrator_login_password The administrator’s login password. myp@sswoRD11!
    minimum_tls_version The minimum TLS version the server allows. 1.2

    See the Terraform Registry to learn more about the azurerm_mssql_server resource’s available arguments.

  3. Save the main.tf file.

Learn more

Updated: