If you're using a local installation, sign in to the Azure CLI by using the az login command. For more information, see How to run the Azure CLI in a Docker container. If you're running on Windows or macOS, consider running Azure CLI in a Docker container. If you prefer to run CLI reference commands locally, install the Azure CLI. For more information, see Quickstart for Bash in Azure Cloud Shell. Use the Bash environment in Azure Cloud Shell. Prepare your environment for the Azure CLI If you don't have an Azure subscription, create an Azure free account before you begin. Make sure to record the generated resource group and server names, so you can manage these resources later. The Azure CLI code blocks in this section create a resource group, server, single database, and server-level IP firewall rule for access to the server. On the Review + create page, after reviewing, select Create. Select Review + create at the bottom of the page: You can also configure database collation and a maintenance window. This creates an AdventureWorksLT sample database so there's some tables and data to query and experiment with, as opposed to an empty blank database. On the Additional settings tab, in the Data source section, for Use existing data, select Sample. Select Next: Additional settings at the bottom of the page. On the Security page, you can choose to start a free trial of Microsoft Defender for SQL, as well as configure Ledger, Managed identities and Transparent data encryption (TDE) if you desire. Select Next: Security at the bottom of the page. Under Connection policy, choose the Default connection policy, and leave the Minimum TLS version at the default of TLS 1.2. Leave Allow Azure services and resources to access this server set to No. On the Networking tab, for Connectivity method, select Public endpoint.įor Firewall rules, set Add current client IP address to Yes. Select Next: Networking at the bottom of the page. To learn more, see backup storage redundancy. Under Backup storage redundancy, choose a redundancy option for the storage account where your backups will be saved. This quickstart uses a serverless database, so leave Service tier set to General purpose (Most budget-friendly, serverless compute) and set Compute tier to Serverless. Under Compute + storage, select Configure database. Leave Want to use SQL elastic pool set to No. Password: Enter a password that meets requirements, and enter it again in the Confirm password field. Location: Select a location from the dropdown list.Īuthentication method: Select Use SQL authentication. So enter something like mysqlserver12345, and the portal lets you know if it's available or not. We can't provide an exact server name to use because server names must be globally unique for all servers in Azure, not just unique within a subscription. Server name: Enter mysqlserver, and add some characters for uniqueness. On the Basics tab of the Create SQL Database form, under Project details, select the desired Azure Subscription.įor Resource group, select Create new, enter myResourceGroup, and select OK.įor Database name, enter mySampleDatabase.įor Server, select Create new, and fill out the New server form with the following values: Under SQL databases, leave Resource type set to Single database, and select Create. To create a single database in the Azure portal, this quickstart starts at the Azure SQL page.īrowse to the Select SQL Deployment option page.
0 Comments
Leave a Reply. |