

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.
