Home > Storage > PowerFlex > White Papers > Microsoft Azure Arc on Dell PowerFlex > Azure Arc-enabled SQL Managed Instance
Azure Arc-enabled SQL Managed Instance enables the deployment of Azure SQL data services anywhere. Microsoft promises to deliver this service with total compatibility with the SQL server database engine and integrated management capabilities. The Azure Arc-enabled SQL Managed Instance was deployed on the PowerFlex platform from the Azure portal.
All the client tools are installed and upgraded to the latest available versions as per the Azure Arc data services pre-requisites. Azure Arc data controller is installed in direct connectivity mode.
Perform the following steps to deploy the Azure Arc-enabled managed SQL instance on the PowerFlex platform:
Log in to Azure Data CLI with the Azure Arc data controller details to ensure that the data controller is present and running. Enter the namespace, username, and password of the data controller to log in.
PS C:\Users\Admin> Azure Data CLI login
Namespace: arc
Username: admin
Password:
Logged in successfully to `https://192.168.150.122:30080` in namespace `arc`. Setting active context to `arc`.
The Azure Arc SQL managed instance is created from the Azure portal. The following set of values is passed as input parameters – resource group, custom location, compute, storage, and administrative account details.
The Azure Arc-enabled SQL Managed Instance state is verified by using the following Azure Data CLI command:
PS C:\Users\Admin> Azure Data CLI arc sql mi list
Name PrimaryEndpoint Replicas State
------- --------------------- ---------- -------
sqldemo 192.168.150.122,30719 1/1 Ready
The Kubernetes cluster is verified by checking if the status of the sqldemo pod is Running.
From the Azure Data Studio, connect to the deployed Azure Arc-enabled SQL Managed Instance by entering the endpoint and credentials.
The deployed Azure Arc-enabled SQL Managed Instance is monitored and managed from the Azure portal and Azure Data Studio that is installed on the Windows client machine.