Рет қаралды 15
Provision an Azure SQL Database resource
In the Azure portal, select + Create a resource from the upper left-hand corner and search for Azure SQL. Then in the resulting Azure SQL page, select Create.
Review the Azure SQL options that are available, and then in the SQL databases tile, ensure Single database is selected and select Create.
Screenshot of the Azure portal showing the Azure SQL page.
Enter the following values on the Create SQL Database page, and leave all other properties with their default setting:
Subscription: Select your Azure subscription.
Resource group: Create a new resource group with a name of your choice.
Database name: AdventureWorks
Server: Select Create new and create a new server with a unique name in any available location.
Use SQL authentication and specify your name as the server admin login and a suitably complex password (remember the password - you’ll need it later!)
Want to use SQL elastic pool?: No
Workload environment: Development
Compute + storage: Leave unchanged
Backup storage redundancy: Locally-redundant backup storage
On the Create SQL Database page, select Next :Networking, and on the
Networking page, in the Network connectivity section, select Public endpoint. Then select Yes for both options in the Firewall rules section to allow access to your database server from Azure services and your current client IP address.
Select Next: Security and set the Enable Microsoft Defender for SQL option to Not now.
Select Next: Additional Settings and on the Additional settings tab, set the Use existing data option to Sample (this will create a sample database that you can explore later)
Select Review + Create, and then select Create to create your Azure SQL database.
microsoftlearn...