Recover prerequisites article. Correct TOC

MikeRayMSFT · MikeRayMSFT · commit 140bbe2a7c65 · 2023-09-28T08:37:17.000-07:00
diff --git a/.openpublishing.redirection.json b/.openpublishing.redirection.json
@@ -41330,11 +41330,6 @@
       "redirect_url": "/sql/sql-server/azure-arc/automatically-connect",
       "redirect_document_id": false
     },
-    {
-      "source_path": "docs/sql-server/azure-arc/prerequisites.md",
-      "redirect_url": "/azure/azure-arc/servers/prerequisites",
-      "redirect_document_id": false
-    },
     {
       "source_path": "docs/sql-server/azure-arc/plan-evaluate-on-azure-virtual-machine.md",
       "redirect_url": "/sql/sql-server/azure-arc/automatically-connect",
diff --git a/docs/sql-server/azure-arc/includes/supported-configurations.md b/docs/sql-server/azure-arc/includes/supported-configurations.md
@@ -0,0 +1,16 @@
+---
+author: MikeRayMSFT
+ms.author: mikeray
+ms.date: 09/28/2023
+ms.topic: include
+---
+
+Azure Arc-enabled [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] supports [!INCLUDE [sssql11-md](../../includes/sssql11-md.md)] and later versions, running on one of the following versions of the Windows or Linux operating system:
+
+- [!INCLUDE [winserver2012-md](../../includes/winserver2012-md.md)] 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](/lifecycle/announcements/sql-server-2012-windows-server-2012-2012-r2-end-of-support).
diff --git a/docs/sql-server/azure-arc/includes/unsupported-configurations.md b/docs/sql-server/azure-arc/includes/unsupported-configurations.md
@@ -0,0 +1,20 @@
+---
+author: MikeRayMSFT
+ms.author: mikeray
+ms.date: 09/28/2023
+ms.topic: include
+---
+
+Azure Arc-enabled [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] doesn't currently support the following configurations:
+
+- [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] running in containers.
+- [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] Failover Cluster Instances (FCI).
+- [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] roles other than the Database Engine, such as Analysis Services (SSAS), Reporting Services (SSRS), or Integration Services (SSIS).
+- [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] editions: Business Intelligence.
+- [!INCLUDE [sql2008-md](../../includes/sql2008-md.md)], [!INCLUDE [sql2008r2-md](../../includes/sql2008r2-md.md)], and older versions.
+- Installing the Arc agent and [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] extension can't be done as part of sysprep image creation.
+- [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] in Azure Virtual Machines.
+- [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] Azure VMware Solution.
+
+> [!NOTE]  
+> Azure extension for [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] fully supports VMware clusters outside of Azure. Although the [!INCLUDE [sssql22-md](../../includes/sssql22-md.md)] Setup Installation Wizard does not support installation of the Azure extension for [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)], this component can be installed from the command line in quiet mode, or by connecting [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] to Azure Arc. For more information, see [Install and connect to Azure](../../database-engine/install-windows/install-sql-server-from-the-command-prompt.md#install-and-connect-to-azure) and [Quickstart: Connect SQL Server machines to Azure Arc](quick-enabled-sql-server.md).
diff --git a/docs/sql-server/azure-arc/overview.md b/docs/sql-server/azure-arc/overview.md
@@ -109,31 +109,11 @@ The following diagram illustrates the architecture of Azure Arc-enabled SQL Serv
 
 ## Supported SQL Server versions and operating systems
 
-Azure Arc-enabled [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] supports [!INCLUDE [sssql11-md](../../includes/sssql11-md.md)] and later versions, running on one of the following versions of the Windows or Linux operating system:
-
-- [!INCLUDE [winserver2012-md](../../includes/winserver2012-md.md)] 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](/lifecycle/announcements/sql-server-2012-windows-server-2012-2012-r2-end-of-support).
+[!INCLUDE [supported-configurations](includes/supported-configurations.md)]
 
 ## Unsupported configurations
 
-Azure Arc-enabled [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] doesn't currently support the following configurations:
-
-- [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] running in containers.
-- [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] Failover Cluster Instances (FCI).
-- [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] roles other than the Database Engine, such as Analysis Services (SSAS), Reporting Services (SSRS), or Integration Services (SSIS).
-- [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] editions: Business Intelligence.
-- [!INCLUDE [sql2008-md](../../includes/sql2008-md.md)], [!INCLUDE [sql2008r2-md](../../includes/sql2008r2-md.md)], and older versions.
-- Installing the Arc agent and [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] extension can't be done as part of sysprep image creation.
-- [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] in Azure Virtual Machines.
-- [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] Azure VMware Solution.
-
-> [!NOTE]  
-> Azure extension for [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] fully supports VMware clusters outside of Azure. Although the [!INCLUDE [sssql22-md](../../includes/sssql22-md.md)] Setup Installation Wizard does not support installation of the Azure extension for [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)], this component can be installed from the command line in quiet mode, or by connecting [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] to Azure Arc. For more information, see [Install and connect to Azure](../../database-engine/install-windows/install-sql-server-from-the-command-prompt.md#install-and-connect-to-azure) and [Quickstart: Connect SQL Server machines to Azure Arc](quick-enabled-sql-server.md).
+[!INCLUDE [unsupported-configurations](includes/unsupported-configurations.md)]
 
 ## Supported Azure regions
 
diff --git a/docs/sql-server/azure-arc/prerequisites.md b/docs/sql-server/azure-arc/prerequisites.md
@@ -0,0 +1,131 @@
+---
+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: 03/08/2023
+ms.topic: conceptual
+ms.custom: references_regions
+---
+
+# Prerequisites
+
+[!INCLUDE [sqlserver](../../includes/applies-to-version/sqlserver.md)]
+
+An Azure Arc-enabled instance of [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] 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 [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)], you need to:
+
+- Have an Azure account with an active subscription. If needed, [create a free Azure Account](https://azure.microsoft.com/free/).
+- Verify [Arc connected machine agent prerequisites](/azure/azure-arc/servers/prerequisites).  The Arc agent must be running in the typical 'full' mode.
+- Verify [Arc connected machine agent network requirements](/azure/azure-arc/servers/network-requirements).
+- Open firewall to [Azure Arc data processing service](#connect-to-azure-arc-data-processing-service).
+- Register resource providers. Specifically:
+  - `Microsoft.AzureArcData`
+  - `Microsoft.HybridCompute`
+
+  For instructions, see [Register resource providers](#register-resource-providers).
+
+### Permissions
+
+To [Connect SQL Servers on Azure Arc-enabled servers at scale using Azure policy](connect-at-scale-policy.md):
+
+- The service principal requires read permission on the subscription.
+
+- The installation account requires:
+
+  - [`User Access Administrator`](/azure/role-based-access-control/built-in-roles#user-access-administrator) role assignment is required in the subscription if you are creating a *new* system assigned managed identity.
+  - [`Resource Policy Contributor`](/azure/role-based-access-control/built-in-roles#resource-policy-contributor) role 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 Onboarding`](/azure/role-based-access-control/built-in-roles#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](/azure/role-based-access-control/built-in-roles#contributor) or [Owner](/azure/role-based-access-control/built-in-roles#owner). For more information, see [Assign Azure roles using the Azure portal](/azure/role-based-access-control/role-assignments-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 [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] 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](overview.md#supported-azure-regions).
+
+For a list of all regions, run this command:
+
+```azcli
+az account list-locations -o table
+```
+
+## Supported SQL Server versions and operating systems
+
+[!INCLUDE [supported-configurations](includes/supported-configurations.md)]
+
+## Unsupported configurations
+
+[!INCLUDE [unsupported-configurations](includes/unsupported-configurations.md)]
+
+## Register resource providers
+
+To register the resource providers, use one of the following methods:
+
+## [Azure portal](#tab/azure)
+
+1. Select **Subscriptions**.
+1. Choose your subscription.
+1. Under **Settings**, select **Resource providers**.
+1. Search for `Microsoft.AzureArcData` and `Microsoft.HybridCompute` and select **Register**.
+
+## [PowerShell](#tab/powershell)
+
+Run:
+
+```powershell
+Register-AzResourceProvider -ProviderNamespace Microsoft.HybridCompute
+Register-AzResourceProvider -ProviderNamespace Microsoft.AzureArcData
+```
+
+## [Azure CLI](#tab/az)
+
+Run:
+
+```azurecli
+az provider register --namespace 'Microsoft.HybridCompute'
+az provider register --namespace 'Microsoft.AzureArcData'
+```
+
+
+---
+## Azure subscription and service limits
+
+Before configuring your [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] instances and machines with Azure Arc, review the Azure Resource Manager [subscription limits](/azure/azure-resource-manager/management/azure-subscription-service-limits#subscription-limits) and [resource group limits](/azure/azure-resource-manager/management/azure-subscription-service-limits#resource-group-limits) to plan for the number of machines to be connected. 
+
+## Supported regions
+
+[!INCLUDE [azure-arc-data-regions](includes/azure-arc-data-regions.md)]
+
+## Next steps
+
+- [Automatically connect your SQL Server to Azure Arc](automatically-connect.md)
+
+
diff --git a/docs/toc.yml b/docs/toc.yml
@@ -10403,12 +10403,12 @@ items:
       href: /azure/azure-sql/managed-instance/sql-managed-instance-paas-overview
     - name: SQL Server on Azure VMs >
       href: /azure/azure-sql/virtual-machines/windows/sql-server-on-azure-vm-iaas-what-is-overview
-- name: Azure Arc-enabled SQL Server
+- name: Azure Arc-enabled SQL
   items:
-    - name: Azure Arc-enabled data services >
-      href: /azure/azure-arc/data/overview
     - name: Azure Arc-enabled SQL Server
       href: sql-server/azure-arc/index.yml
+    - name: Azure Arc-enabled data services >
+      href: /azure/azure-arc/data/overview
     - name: Overview
       items:
       - name: What is Azure Arc-enabled SQL Server?
