Create SQL Managed Instance enabled by Azure Arc using Azure Data Studio
This document demonstrates how to install Azure SQL Managed Instance - Azure Arc using Azure Data Studio.
Prerequisites
Before you can proceed with the tasks in this article, you need to have the necessary tools. All deployments require the following tools:
Azure Data Studio
Azure Arc extension for Azure Data Studio
Azure CLI (
az
)arcdata
extension for Azure CLIkubectl
Additional client tools depending your environment. For a more comprehensive list, see Client tools.
In addition to the required tools, to complete the tasks, you need an Azure Arc data controller.
Steps
- Launch Azure Data Studio
- On the Connections tab, select on the three dots on the top left and choose New Deployment....
- From the deployment options, select Azure SQL managed instance.
Note
You may be prompted to install the appropriate CLI here if it is not currently installed.
Select Select.
Azure Data Studio opens Azure SQL managed instance.
For Resource Type, choose Azure SQL managed instance - Azure Arc.
Accept the privacy statement and license terms
Review the required tools. Follow instructions to update tools before you proceed.
Select Next.
Azure Data Studio allows you to set your specifications for the managed instance. The following table describes the fields:
Setting Description Required or optional Target Azure Controller Name of the Azure Arc data controller. Required Instance name Managed instance name. Required Username System administrator user name. Required System administrator password SQL authentication password for the managed instance. The passwords must be at least eight characters long and contain characters from three of the following four categories: Latin uppercase letters, Latin lowercase letters, numbers, and non-alphanumeric characters.
Confirm the password.Required Service tier Specify the appropriate service tier: Business Critical or General Purpose. Required I already have a SQL Server License Select if this managed instance will use a license from your organization. Optional Storage Class (Data) Select from the list. Required Volume Size in Gi (Data) The amount of space in gibibytes to allocate for data. Required Storage Class (Database logs) Select from the list. Required Volume Size in Gi (Database logs) The amount of space in gibibytes to allocate for database transaction logs. Required Storage Class (Logs) Select from the list. Required Volume Size in Gi (Logs) The amount of space in gibibytes to allocate for logs. Required Storage Class (Backups) Select from the list. Specify a ReadWriteMany (RWX) capable storage class for backups. Learn more about access modes. If this storage class isn't RWX capable, the deployment may not succeed. Required Volume Size in Gi (Backups) The size of the storage volume to be used for database backups in gibibytes. Required Cores Request The number of cores to request for the managed instance. Integer. Optional Cores Limit The request for the capacity for the managed instance in gigabytes. Integer. Optional Memory Request Select from the list. Required Point in time retention (days) The number of days to keep your point in time backups. Optional After you've set all of the required values, Azure Data Studio enables the Deploy button. If this control is disabled, verify that you have all required settings configured.
Select the Deploy button to create the managed instance.
After you select the deploy button, the Azure Arc data controller initiates the deployment. The deployment creates the managed instance. The deployment process takes a few minutes to create the data controller.
Connect from Azure Data Studio
View all the SQL Managed Instances provisioned to this data controller. Use the following command:
az sql mi-arc list --k8s-namespace <namespace> --use-k8s
Output should look like this, copy the ServerEndpoint (including the port number) from here.
Name Replicas ServerEndpoint State
------------ ---------- ----------------- -------
sqlinstance1 1/1 25.51.65.109:1433 Ready
- In Azure Data Studio, under Connections tab, select the New Connection on the Servers view
- Under Connection>Server, paste the ServerEndpoint
- Select SQL Login as the Authentication type
- Enter sa as the user name
- Enter the password for the
sa
account - Optionally, enter the specific database name to connect to
- Optionally, select/Add New Server Group as appropriate
- Select Connect to connect to the Azure SQL Managed Instance - Azure Arc
Related information
Now try to monitor your SQL instance
Pripomienky
https://aka.ms/ContentUserFeedback.
Pripravujeme: V priebehu roka 2024 postupne zrušíme službu Problémy v službe GitHub ako mechanizmus pripomienok týkajúcich sa obsahu a nahradíme ju novým systémom pripomienok. Ďalšie informácie nájdete na stránke:Odoslať a zobraziť pripomienky pre