Prerequisites
An Azure Arc-enabled instance of SQL Server is an instance on-premises or in a cloud provider that is connected to Azure Arc. This article explains those prerequisites.
Before you deploy
Before you can Arc-enable an instance of SQL Server, you need to:
Have an Azure account with an active subscription. If needed, create a free Azure Account.
Verify Arc connected machine agent prerequisites. The Arc agent must be running in the typical 'full' mode.
Open firewall to Azure Arc data processing service.
Register resource providers. Specifically:
Microsoft.AzureArcDataMicrosoft.HybridCompute
For instructions, see Register resource providers.
Permissions
To Connect SQL Servers on Azure Arc-enabled servers at scale using Azure policy:
The service principal requires read permission on the subscription.
The installation account requires:
User Access Administratorrole assignment is required in the subscription if you are creating a new system assigned managed identity.Resource Policy Contributorrole assignment for the scope that you're targeting. The scope may be either subscription or resource group.
For all the other onboarding methods:
The service principal requires read permission on the subscription.
User or service principal must have permissions in the Azure resource group to complete the task. Specifically:
Azure Connected Machine OnboardingroleMicrosoft.AzureArcData/register/actionMicrosoft.HybridCompute/machines/extensions/readMicrosoft.HybridCompute/machines/extensions/write
Users can be assigned to built-in roles that have these permissions, for example Contributor or Owner. For more information, see Assign Azure roles using the Azure portal.
- Have local administrator permission on the operating system to install and configure the agent.
- For Linux, use the root account.
- For Windows, use an account that is a member of the Local Administrators group.
Connect to Azure Arc data processing service
Arc-enabled SQL Server requires outbound connection to Azure Arc data processing service. Each virtual or physical server requires connectivity to:
- URL:
san-af-<region>-prod.azurewebsites.net - Port: 443
- Direction: Outbound
To get the region segment of a regional endpoint, remove all spaces from the Azure region name. For example, East US 2 region, the region name is eastus2.
For example: san-af-<region>-prod.azurewebsites.net should be san-af-eastus2-prod.azurewebsites.net in the East US 2 region.
For a list of supported regions, review Supported Azure regions.
For a list of all regions, run this command:
az account list-locations -o table
Supported SQL Server versions and operating systems
Azure Arc-enabled SQL Server supports SQL Server 2012 (11.x) and later versions, running on one of the following versions of the Windows or Linux operating system:
- Windows Server 2012 and later versions
- Ubuntu 20.04 (x64)
- Red Hat Enterprise Linux (RHEL) 8 (x64)
- SUSE Linux Enterprise Server (SLES) 15 (x64)
Important
Windows Server 2012 and Windows Server 2012 R2 support ends on October 10, 2023. For more information, see SQL Server 2012 and Windows Server 2012/2012 R2 end of support.
Azure Arc-enabled SQL Server doesn't currently support the following configurations:
- SQL Server running in containers.
- SQL Server Failover Cluster Instances (FCI).
- SQL Server roles other than the Database Engine, such as Analysis Services (SSAS), Reporting Services (SSRS), or Integration Services (SSIS).
- SQL Server editions: Business Intelligence.
- SQL Server 2008 (10.0.x), SQL Server 2008 R2 (10.50.x), and older versions.
- Installing the Arc agent and SQL Server extension can't be done as part of sysprep image creation.
- SQL Server in Azure Virtual Machines.
- SQL Server Azure VMware Solution.
Note
Azure extension for SQL Server fully supports VMware clusters outside of Azure. Although the SQL Server 2022 (16.x) Setup Installation Wizard does not support installation of the Azure extension for SQL Server, this component can be installed from the command line in quiet mode, or by connecting SQL Server to Azure Arc. For more information, see Install and connect to Azure and Connect your SQL Server to Azure Arc.
Register resource providers
To register the resource providers, use one of the following methods:
- Select Subscriptions.
- Choose your subscription.
- Under Settings, select Resource providers.
- Search for
Microsoft.AzureArcDataandMicrosoft.HybridComputeand select Register.
Azure subscription and service limits
Before configuring your SQL Server instances and machines with Azure Arc, review the Azure Resource Manager subscription limits and resource group limits to plan for the number of machines to be connected.
Supported regions
Arc-enabled SQL Server is available in the following regions:
- East US
- East US 2
- West US
- West US 2
- West US 3
- Central US
- North Central US
- South Central US
- Canada Central
- UK South
- France Central
- West Europe
- North Europe
- Japan East
- Korea Central
- Southeast Asia
- Australia East
Next steps
Feedback
Submit and view feedback for