Skip to content

prerequisites.md

Latest commit

 

History

History
108 lines (76 loc) · 4.98 KB

prerequisites.md

File metadata and controls

108 lines (76 loc) · 4.98 KB
title Azure Arc-enabled SQL Server prerequisites
description Describes prerequisites required by of Azure Arc-enabled SQL Server.
author anosov1960
ms.author sashan
ms.reviewer mikeray, randolphwest
ms.date 01/25/2023
ms.service sql
ms.topic conceptual
ms.custom references_regions

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

Note

If you connected an instance of SQL Server to Azure Arc prior to December 2020, you need to follow the prerequisite steps to migrate the existing Arc-enabled SQL Server resources to the new namespace.

Before you can Arc-enable an instance of SQL Server you need to:

Permissions

To Connect SQL Servers on Azure Arc-enabled servers at scale using Azure policy for you to create an Azure Policy assignment, your subscription requires the Resource Policy Contributor role assignment for the scope that you're targeting. The scope may be either subscription or resource group. Further, if you are going to create a new system assigned managed identity, you need the User Access Administrator role assignment in the subscription.

For all the other onboarding methods, user or service principal must have permissions in the Azure resource group to complete the task. Specifically:

  • Azure Connected Machine Onboarding role
  • Microsoft.AzureArcData/register/action
  • Microsoft.HybridCompute/machines/extensions/read
  • Microsoft.HybridCompute/machines/extensions/write

Users can be assigned to built-in roles that have these permissions, for example Contributor or Owner. See Assign Azure roles using the Azure portal for more information.

  • 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.

Supported SQL Server versions and operating systems

Azure Arc-enabled SQL Server supports SQL Server 2012 or higher running on one of the following versions of the Windows or Linux operating system:

  • Windows Server 2012 R2 and higher
  • Ubuntu 20.04 (x64)
  • Red Hat Enterprise Linux (RHEL) 8 (x64)
  • SUSE Linux Enterprise Server (SLES) 15 (x64)

Note

Azure Arc-enabled SQL Server does not support the following configurations currently:

  • 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, SQL Server 2008 R2, and older.
  • Installing the Arc agent and SQL Server extension cannot be done as part of sysprep image creation.

Register resource providers

To register the resource providers, use one of the methods below:

Azure portal

  1. Select Subscriptions.
  2. Choose your subscription.
  3. Under Settings, select Resource providers.
  4. Search for Microsoft.AzureArcData and Microsoft.HybridCompute and select Register.

PowerShell

Run:

Register-AzResourceProvider -ProviderNamespace Microsoft.HybridCompute
Register-AzResourceProvider -ProviderNamespace Microsoft.AzureArcData

Azure CLI

Run:

az provider register --namespace 'Microsoft.HybridCompute'
az provider register --namespace 'Microsoft.AzureArcData'

Azure subscription and service limits

The maximum number of resources in a resource group is 800, per resource type. This limitation applies to Azure Arc-enabled SQL Server instances and databases. 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

[!INCLUDE azure-arc-data-regions]

Next steps