Use CLI to create a single Azure SQL database and configure a firewall rule
This Azure CLI script example creates an Azure SQL database and configure a server-level firewall rule. Once the script has been successfully run, the SQL Database can be accessed from all Azure services and the configured IP address.
Use Azure Cloud Shell
Azure hosts Azure Cloud Shell, an interactive shell environment that you can use through your browser. You can use either Bash or PowerShell with Cloud Shell to work with Azure services. You can use the Cloud Shell preinstalled commands to run the code in this article without having to install anything on your local environment.
To start Azure Cloud Shell:
|Select Try It in the upper-right corner of a code block. Selecting Try It doesn't automatically copy the code to Cloud Shell.|
|Go to https://shell.azure.com, or select the Launch Cloud Shell button to open Cloud Shell in your browser.|
|Select the Cloud Shell button on the top-right menu bar in the Azure portal.|
To run the code in this article in Azure Cloud Shell:
Start Cloud Shell.
Select the Copy button on a code block to copy the code.
Paste the code into the Cloud Shell session by selecting Ctrl+Shift+V on Windows and Linux or by selecting Cmd+Shift+V on macOS.
Select Enter to run the code.
If you choose to install and use the CLI locally, this topic requires that you are running the Azure CLI version 2.0 or later. Run
az --version to find the version. If you need to install or upgrade, see Install the Azure CLI.
#!/bin/bash # set execution context (if necessary) az account set --subscription <replace with your subscription name or id> # Set the resource group name and location for your server resourceGroupName=myResourceGroup-$RANDOM location=westus2 # Set an admin login and password for your database adminlogin=ServerAdmin password=`openssl rand -base64 16` # password=<EnterYourComplexPasswordHere1> # The logical server name has to be unique in the system servername=server-$RANDOM # The ip address range that you want to allow to access your DB startip=0.0.0.0 endip=0.0.0.0 # Create a resource group az group create \ --name $resourceGroupName \ --location $location # Create a logical server in the resource group az sql server create \ --name $servername \ --resource-group $resourceGroupName \ --location $location \ --admin-user $adminlogin \ --admin-password $password # Configure a firewall rule for the server az sql server firewall-rule create \ --resource-group $resourceGroupName \ --server $servername \ -n AllowYourIp \ --start-ip-address $startip \ --end-ip-address $endip # Create a database in the server with zone redundancy as false az sql db create \ --resource-group $resourceGroupName \ --server $servername \ --name mySampleDatabase \ --sample-name AdventureWorksLT \ --edition GeneralPurpose \ --family Gen4 \ --capacity 1 \ --zone-redundant false # Zone redundancy is only supported in the premium and business critical service tiers # Echo random password echo $password
Clean up deployment
Use the following command to remove the resource group and all resources associated with it.
az group delete --name $resourceGroupName
This script uses the following commands. Each command in the table links to command specific documentation.
|az group create||Creates a resource group in which all resources are stored.|
|az sql server create||Creates a SQL Database server that hosts a single database or elastic pool.|
|az sql server firewall create||Creates a firewall rule to allow access to all single databases an elastic pools on the SQL Database server from the entered IP address range.|
|az sql db create||Creates a single database or elastic pool.|
|az group delete||Deletes a resource group including all nested resources.|
For more information on the Azure CLI, see Azure CLI documentation.
Additional SQL Database CLI script samples can be found in the Azure SQL Database documentation.